Crony's Dungeon
  • Communities
  • Create Post
  • heart
    Support Lemmy
  • search
    Search
  • Login
  • Sign Up
Sunshine@piefed.zip to Linux@programming.devEnglish · 17 days ago

Linux 7.0 Cuts PostgreSQL Performance in Half

winbuzzer.com

external-link
message-square
9
link
fedilink
99
external-link

Linux 7.0 Cuts PostgreSQL Performance in Half

winbuzzer.com

Sunshine@piefed.zip to Linux@programming.devEnglish · 17 days ago
message-square
9
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.
  • Rimu@piefed.social
    link
    fedilink
    English
    arrow-up
    27
    ·
    17 days 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?

    • deegeese@sopuli.xyz
      link
      fedilink
      arrow-up
      7
      arrow-down
      2
      ·
      16 days ago

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

    • Die4Ever@retrolemmy.com
      link
      fedilink
      English
      arrow-up
      2
      ·
      16 days ago

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

  • realitaetsverlust@piefed.zip
    link
    fedilink
    English
    arrow-up
    17
    ·
    16 days 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
      1
      ·
      14 days ago

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

      • realitaetsverlust@piefed.zip
        link
        fedilink
        English
        arrow-up
        1
        ·
        13 days ago

        Because that’s what you do with important software? You don’t want to stack up potential issues until the final release for the public.

  • Die4Ever@retrolemmy.com
    link
    fedilink
    English
    arrow-up
    7
    ·
    edit-2
    16 days ago

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

    Which is expected to be faster in the end?

  • just_another_person@lemmy.world
    link
    fedilink
    arrow-up
    7
    arrow-down
    1
    ·
    16 days 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.

  • lacaio 🇧🇷🏴‍☠️🇸🇴@lemmy.eco.br
    link
    fedilink
    arrow-up
    1
    arrow-down
    1
    ·
    16 days 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?

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: !linux@programming.dev

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

Also, check out:

  • !linux_memes@programming.dev
  • !linuxphones@lemmy.ca
  • our Matrix group chat
  • !reactos@programming.dev

Original icon base courtesy of lewing@isc.tamu.edu and The GIMP

Visibility: Public
globe

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

  • 381 users / day
  • 1.32K users / week
  • 4.05K users / month
  • 9.63K users / 6 months
  • 1 local subscriber
  • 13.3K subscribers
  • 4.34K Posts
  • 28.9K Comments
  • Modlog
  • mods:
  • Ategon@programming.dev
  • adr1an@programming.dev
  • dwraf_of_ignorance@programming.dev
  • BE: 0.19.13
  • Modlog
  • Legal
  • Instances
  • Docs
  • Code
  • join-lemmy.org