Hello,

I'm running PostgreSQL 7.3.15 on a RedHat Enterprise 3 dedicated server
for website hosting.
The system is a P4 2.8 Ghz with 4 GB RAM.
Can someone please suggest how to optimize postgresql.conf settings for
performance ?
I'm not expert on PostgreSQL, have found many how-to's online but still
have performance issues with the database.
Please let me know if you need further information.

Thanks in advance for your help
A.

AndyX <nomorespam (AT) please (DOT) it> wrote:
I have been told that the golden rule of tuning is not to do it unless
indicated.

If you have lots of memory, you should increase

shared_buffers (shared memory allocated, in 8MB units, default 16)
sort_mem (memory used for sort and hash, in 1MB units, default 1)

A good way of tuning would be to use a more recent version of PostgreSQL
than the ancient one that comes with RHEL3.

Yours,
Laurenz Albe