>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. My personal opinion is that certain parameters in postgres.conf are simply too technical in nature for a application developer like me, it becomes more of a trial and error kind of frustrating process. If there a utility that understands the system specification on which postgres is going to run and change the paramters accordingly, that would help. Thanks, Saurabh On Mon, Jul 6, 2009 at 12:37 PM, Guillaume Cottenceau <g...@mnc.ch> wrote: > Mark Mielke <mark 'at' mark.mielke.cc> writes: > > > On 07/06/2009 01:48 AM, Saurabh Dave wrote: > >> We are bundling PostgreSQL 8.3.7 with our Java based application. > > [...] > > > PostgreSQL 8.4 comes with significantly improved "out of the box" > > configuration. I think that is what you are looking for. Specifically, > > you are probably looking for "autovacuum" to be enabled. > > autovacuum is enabled by default on PG 8.3 as well. > > -- > Guillaume Cottenceau > > -- > Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-performance >