awful.systems
  • Communities
  • Create Post
  • 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
11
link
fedilink
119
external-link

Linux 7.0 Cuts PostgreSQL Performance in Half

winbuzzer.com

Sunshine@piefed.zip to Linux@programming.devEnglish · 17 days 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.
  • Endmaker@ani.social
    link
    fedilink
    English
    arrow-up
    65
    ·
    17 days 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
      23
      ·
      17 days ago

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

    • BlackEco@lemmy.blackeco.com
      link
      fedilink
      arrow-up
      9
      ·
      17 days 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.

  • Rimu@piefed.social
    link
    fedilink
    English
    arrow-up
    32
    ·
    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
      9
      ·
      17 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
    19
    ·
    17 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
        ·
        14 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?

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

  • 236 users / day
  • 974 users / week
  • 3.78K users / month
  • 10.1K users / 6 months
  • 5 local subscribers
  • 13.3K subscribers
  • 3.5K Posts
  • 24.8K Comments
  • Modlog
  • mods:
  • Ategon@programming.dev
  • adr1an@programming.dev
  • dwraf_of_ignorance@programming.dev
  • BE: 0.19.12
  • Modlog
  • Instances
  • Docs
  • Code
  • join-lemmy.org