TUNED_PROFILES_POSTGRESQL(7)

πŸ“¦
version 2.28.0 Β· 2 versions
  • 2.28.0 Β· alpine 3.24, arch rolling, centos-stream 10, centos-stream 9, debian bookworm, debian trixie, fedora 43, fedora 44, nixpkgs unstable, opensuse-leap 16.0, ubuntu noble, ubuntu resolute, ubuntu stonking (latest)
  • 2.15.0 Β· ubuntu jammy
, in alpine 3.24, arch rolling, centos-stream 10, centos-stream 9, debian bookworm, debian trixie, fedora 43, fedora 44, nixpkgs unstable, opensuse-leap 16.0, ubuntu noble, ubuntu resolute, ubuntu stonking

πŸ’… TUNED_PROFILES_POSTGRESQL β€” bestie edition ✨

okay so you found the tuned-profiles-postgresql page in the TuneD manual, section 7, and honestly? good for you. this one is short and sweet but it's important, so let's get into it 🫢

🌸 NAME 🌸

tuned-profiles-postgresql β€” the whole rundown of the profiles that TuneD ships for the PostgreSQL Server πŸ’–

✨ DESCRIPTION ✨

so here's the vibe: these profiles exist specifically for the PostgreSQL Database server. that's the whole point. no cap. 🐘

πŸ‘‘ PROFILES πŸ‘‘

here's what you actually get, bestie:

  • postgresql β€” this one is optimized for PostgreSQL databases, and it's built on top of the throughput-performance profile. on top of that whole situation, it additionally turns off transparent huge pages and also tweaks some other performance-related kernel parameters. it's giving "we came to optimize and we did not come to play" πŸ”₯
not me being dramatic but like β€” yes, it really does disable transparent huge pages. that's a fact, not a vibe. periodt.

πŸŽ€ FILES πŸŽ€

these are the paths in question, exactly as they are:

/etc/tuned/*
/usr/lib/tuned/*

πŸ¦‹ SEE ALSO πŸ¦‹

go read these too, they're all part of the family (iykyk):

πŸ’œ AUTHOR πŸ’œ

the icons who made this happen, shoutout to them:

  • Jaroslav Ε karvada <jskarvad@redhat.com>
  • Tigran Mkrtchyan <tigran.mkrtchyan@desy.de>

that's literally the whole page, bestie πŸ“ and the receipts: this one came from the Fedora Power Management SIG, dated 29 Jul 2020, and it's page TUNED_PROFILES_POSTGRESQL(7) in the TuneD manual. slay, go optimize your database πŸ’…βœ¨

πŸ“¦ where this page comes from