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-questions@xxxxxxxxxxxxxx' Subject: RE: 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:craig@xxxxxxxxxxxxxxxxxxxxx] Sent: Tuesday, January 11, 2011 2:08 AM To: Karayappalli, Raghunath (Raghu) Cc: pgsql-questions@xxxxxxxxxxxxxx Subject: Re: 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
