BROWNTOWN
  • Communities
  • Create Post
  • Create Community
  • heart
    Support Lemmy
  • search
    Search
  • Login
  • Sign Up
Sunshine@piefed.zip to Linux@programming.devEnglish · 2 months ago

Linux 7.0 Cuts PostgreSQL Performance in Half

winbuzzer.com

external-link
message-square
11
link
fedilink
1
external-link

Linux 7.0 Cuts PostgreSQL Performance in Half

winbuzzer.com

Sunshine@piefed.zip to Linux@programming.devEnglish · 2 months ago
message-square
11
link
fedilink
An AWS engineer has reported PostgreSQL throughput dropping to 0.51x on Linux 7.0 after a kernel preemption change, with no fix before stable release.
alert-triangle
You must log in or # to comment.
  • Die4Ever@retrolemmy.com
    link
    fedilink
    English
    arrow-up
    0
    ·
    2 months ago

    I’ll be curious to see benchmarks of PREEMPT_NONE vs rseq once PostgreSQL patches this

  • lacaio 🇧🇷🏴‍☠️🇸🇴@lemmy.eco.br
    link
    fedilink
    arrow-up
    0
    ·
    2 months ago

    Maybe Linux is considering prioritizing consumer hardware (safety, less room for human error)? Android is already a thing, so maybe there is pressure for prioritizing consumer hardware?

  • realitaetsverlust@piefed.zip
    link
    fedilink
    English
    arrow-up
    0
    ·
    2 months ago

    I think it’s a bit weird that postgres hasn’t done any testing on the new kernel. That’s something I would kinda expect from a major database. The fact this was only found in production is a bit … weird.

    • balian@lemmy.libertarianfellowship.org
      link
      fedilink
      arrow-up
      0
      ·
      2 months ago

      Why would they? The current stable kernel release is still v6.19

  • Endmaker@ani.social
    link
    fedilink
    English
    arrow-up
    0
    ·
    2 months ago

    kernel maintainers are pushing the fix burden onto PostgreSQL

    Maybe it isn’t applicable in this context, but didn’t Linus Torvalds send an angry email on an adjacent topic, but regarding the same philosophy?

    Found it: we do not break userspace

    Disclaimer: I am a noob when it comes to Linux and building operating systems.

    • Laser@feddit.org
      link
      fedilink
      arrow-up
      0
      ·
      2 months ago

      Well, technically, it’s not broken, just slower

    • BlackEco@lemmy.blackeco.com
      link
      fedilink
      arrow-up
      0
      ·
      2 months ago

      Regardless of Linus’s philosophy, such a change in Postgresql would need to be backported to previous versions, because migrating from one major release to another is far from being straightforward.

  • just_another_person@lemmy.world
    link
    fedilink
    arrow-up
    0
    ·
    2 months ago

    This has been known for awhile, and this was already accepted to be an issue with PH memory handling. Not weird, rare or otherwise, it will get fixed.

  • Rimu@piefed.social
    link
    fedilink
    English
    arrow-up
    0
    ·
    2 months ago

    Wouldn’t it make sense to merge in rseq support well in advance of removing PREEMPT_NONE, not do both at the same time?

    • Die4Ever@retrolemmy.com
      link
      fedilink
      English
      arrow-up
      0
      ·
      2 months ago

      sounds like rseq has been around since 2018 https://www.phoronix.com/news/Restartable-Sequences-Speed

    • deegeese@sopuli.xyz
      link
      fedilink
      arrow-up
      0
      ·
      2 months ago

      But that hurts the ego of the kernel developer because they have to wait for the next release.

Linux@programming.dev

linux@programming.dev

Subscribe from Remote Instance

Create a post
You are not logged in. However you can subscribe from another Fediverse account, for example Lemmy or Mastodon. To do this, paste the following into the search field of your instance: [email protected]

A community for everything relating to the GNU/Linux operating system (except the memes!)

Also, check out:

  • [email protected]
  • [email protected]
  • our Matrix group chat
  • [email protected]

Original icon base courtesy of [email protected] and The GIMP

Visibility: Public
globe

This community can be federated to other instances and be posted/commented in by their users.

  • 14 users / day
  • 164 users / week
  • 819 users / month
  • 3.03K users / 6 months
  • 0 local subscribers
  • 13.8K subscribers
  • 2.13K Posts
  • 17K Comments
  • Modlog
  • mods:
  • Ategon@programming.dev
  • adr1an@programming.dev
  • dwraf_of_ignorance@programming.dev
  • BE: 0.19.17
  • Modlog
  • Instances
  • Docs
  • Code
  • join-lemmy.org