Lemmy LIETUVA
  • Communities
  • Create Post
  • Create Community
  • heart
    Support Lemmy
  • search
    Search
  • Login
  • Sign Up
Sunshine@piefed.zip to Linux@programming.devEnglish · 6 days 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 · 6 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.
  • Die4Ever@retrolemmy.com
    link
    fedilink
    English
    arrow-up
    0
    ·
    5 days 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
    ·
    5 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?

  • realitaetsverlust@piefed.zip
    link
    fedilink
    English
    arrow-up
    0
    ·
    5 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
      0
      ·
      3 days ago

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

  • just_another_person@lemmy.world
    link
    fedilink
    arrow-up
    0
    ·
    5 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.

  • Endmaker@ani.social
    link
    fedilink
    English
    arrow-up
    0
    ·
    6 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.

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

    • Laser@feddit.org
      link
      fedilink
      arrow-up
      0
      ·
      6 days ago

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

  • Rimu@piefed.social
    link
    fedilink
    English
    arrow-up
    0
    ·
    6 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?

    • Die4Ever@retrolemmy.com
      link
      fedilink
      English
      arrow-up
      0
      ·
      5 days 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
      ·
      5 days 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: !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.

  • 32 users / day
  • 290 users / week
  • 452 users / month
  • 466 users / 6 months
  • 0 local subscribers
  • 13.2K subscribers
  • 149 Posts
  • 951 Comments
  • Modlog
  • mods:
  • Ategon@programming.dev
  • adr1an@programming.dev
  • dwraf_of_ignorance@programming.dev
  • BE: 0.19.17
  • Modlog
  • Legal
  • Instances
  • Docs
  • Code
  • join-lemmy.org