Comments on: PostgreSQL Performance Tuning: Optimizing Database Parameters for Maximum Efficiency https://www.percona.com/blog/tuning-postgresql-database-parameters-to-optimize-performance/ Mon, 29 Apr 2024 16:04:06 +0000 hourly 1 https://wordpress.org/?v=6.5.2 By: joshuamills235 https://www.percona.com/blog/tuning-postgresql-database-parameters-to-optimize-performance/#comment-10971068 Fri, 02 Aug 2019 13:43:18 +0000 https://www.percona.com/blog/?p=51472#comment-10971068 In this post you are very thoughtful . I am very happy to read this post. It’s so motivational post for me. I would like to very thankful for this best and most important information. For more info :-https://www.autoupgrades.co.nz/

]]> By: Ibrar Ahmed https://www.percona.com/blog/tuning-postgresql-database-parameters-to-optimize-performance/#comment-10969646 Mon, 03 Sep 2018 14:50:41 +0000 https://www.percona.com/blog/?p=51472#comment-10969646 Most of the tuning advices are for the dedicated “database” server. In case of shared system where you are running database and some other server on a single machine need to be tuned accordingly.

]]> By: Glyn https://www.percona.com/blog/tuning-postgresql-database-parameters-to-optimize-performance/#comment-10969643 Mon, 03 Sep 2018 10:26:32 +0000 https://www.percona.com/blog/?p=51472#comment-10969643 That shared_buffer advice isn’t great, especially if applied to modern systems with large volumes of ram.

Generally there’s a tipping point, and it’s much lower than you’d think. A better approach is to use pg_buffercache extension to inspect the system under typical load and tune down.

]]> By: fpuga https://www.percona.com/blog/tuning-postgresql-database-parameters-to-optimize-performance/#comment-10969640 Sat, 01 Sep 2018 15:42:03 +0000 https://www.percona.com/blog/?p=51472#comment-10969640 I understad that most of this suggestions like using 25% of RAM for shared_buffer is for servers that are only running PostgreSQL and not for servers that also run a web server or other services. Is this true?

]]>