I am trying to tune postgres 7.1. It's running on a Linux server with Apache and PHP. The web site is fairly DB intensive. Right now, it has 256MB.
The first thing I looked at is shared_buffers and max_connections. I set max_connections to 128 and shared_buffers to 1024 (times 8192 bytes = 8MB, am I right?). Now, is this total memory allocated to all child processes or there's more to it. How about the number of connections? Too high, ok?
Any other parameters I should look at?
I would welcome any suggestions and/or sample configuration parameters.
Thanks.
Bojan
The first thing I looked at is shared_buffers and max_connections. I set max_connections to 128 and shared_buffers to 1024 (times 8192 bytes = 8MB, am I right?). Now, is this total memory allocated to all child processes or there's more to it. How about the number of connections? Too high, ok?
Any other parameters I should look at?
I would welcome any suggestions and/or sample configuration parameters.
Thanks.
Bojan