I am missing some of your questions: what are the tuning parameters are you referring here that would prevent running auto vacuum?
thanks/ regards, raghu -----Original Message----- From: Karayappalli, Raghunath (Raghu) Sent: Tuesday, January 11, 2011 9:38 AM To: 'Craig Ringer' Cc: 'pgsql-questi...@postgresql.org' Subject: RE: [GENERAL] database is growing... 1GB per day basis I am using the version 8.2. I have enabled auto vacuum (assuming that you are referring to the "autovacuum = on" configuration). thanks/ regards, raghu -----Original Message----- From: Craig Ringer [mailto:cr...@postnewspapers.com.au] Sent: Tuesday, January 11, 2011 2:08 AM To: Karayappalli, Raghunath (Raghu) Cc: pgsql-questi...@postgresql.org Subject: Re: [GENERAL] database is growing... 1GB per day basis On 01/11/2011 02:03 PM, Karayappalli, Raghunath (Raghu) wrote: > 1.We observe that database is growing very fast - many sets of files > with size more than 1 GB. Please see some sample snippets of the file > lists: What version of Pg are you using? Got lots of connections in 'IDLE IN TRANSACTION' state as listed in "SELECT * FROM pg_stat_activity;" ? Is autovacuum enabled? Have you done anything like tuned autovacuum to hardly ever run? What're the results of running 'VACUUM ANALYZE VERBOSE;' in the problem database? -- Craig Ringer -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
