>No offense intended - but have you looked at the
documentation for postgresql.conf?
>If you are going to include PostgreSQL in your application, I'd
highly recommend you >understand what you are including. :-)
I
had a look into the documentation of postgres.conf, and tried a lot
with changing paramters I thought would improve the performance, but in
vain.
Autovaccum is enabled by default in 8.3.7 , but i reduced the nap time
so that it happens more frequently.
As others have pointed tuning is not a caned answer hence all the
config options to start with. But to change the configuration to
something a bench mark must be made. The only way to do that is
identify the common SQL commands sent to the server then run explain
analyze so you know what the server is doing. Then post the the
results along with Config file and we can make suggestions