diff options
| author | Jani Välimaa <wally@mageia.org> | 2025-05-11 12:14:36 +0300 |
|---|---|---|
| committer | Jani Välimaa <wally@mageia.org> | 2025-05-11 12:14:36 +0300 |
| commit | 63750daa63f07dc57e5a95d3343452f58a48f7f6 (patch) | |
| tree | bd642167925d3c0e68d1be63d39551e0aa2903ad /modules/postgresql | |
| parent | a39a332671b7cb8e99c3ecf8954aeb20223eff14 (diff) | |
| download | puppet-63750daa63f07dc57e5a95d3343452f58a48f7f6.tar puppet-63750daa63f07dc57e5a95d3343452f58a48f7f6.tar.gz puppet-63750daa63f07dc57e5a95d3343452f58a48f7f6.tar.bz2 puppet-63750daa63f07dc57e5a95d3343452f58a48f7f6.tar.xz puppet-63750daa63f07dc57e5a95d3343452f58a48f7f6.zip | |
Increase PostgreSQL server shared_buffers to 4GB
According to upstream a reasonable starting value for shared_buffers is 25% of the memory which would be actually 8GB in sucuk.
Diffstat (limited to 'modules/postgresql')
| -rw-r--r-- | modules/postgresql/templates/postgresql.conf | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/modules/postgresql/templates/postgresql.conf b/modules/postgresql/templates/postgresql.conf index bc5caa09..bc13ace4 100644 --- a/modules/postgresql/templates/postgresql.conf +++ b/modules/postgresql/templates/postgresql.conf @@ -113,7 +113,7 @@ ssl = on # - Memory - -shared_buffers = 24MB # min 128kB +shared_buffers = 4096MB # min 128kB # (change requires restart) #temp_buffers = 8MB # min 800kB #max_prepared_transactions = 0 # zero disables the feature |