In many situations, the best way to speed up a stock Postgres install is to increase shared memory buffers.
Shared buffers are counted in 8k blocks. elow Below is a configuration where Postgres can use (28672*8) = 229376k.
postgresql.conf:
...
In many situations, the best way to speed up a stock Postgres install is to increase shared memory buffers.
Shared buffers are counted in 8k blocks. elow Below is a configuration where Postgres can use (28672*8) = 229376k.
postgresql.conf:
...