Quick Links

Re: database is growing... 1GB per day basis

From:	Craig Ringer <craig(at)postnewspapers(dot)com(dot)au>
To:	"Karayappalli, Raghunath (Raghu)" <raghunath(at)avaya(dot)com>
Cc:	pgsql-questions(at)postgresql(dot)org
Subject:	Re: database is growing... 1GB per day basis
Date:	2011-01-11 10:07:57
Message-ID:	4D2C2BFD.4090604@postnewspapers.com.au
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	pgsql-general

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

In response to

database is growing... 1GB per day basis at 2011-01-11 03:03:13 from Karayappalli, Raghunath (Raghu)

Responses

Re: database is growing... 1GB per day basis at 2011-01-11 17:37:42 from Karayappalli, Raghunath (Raghu)
Re: database is growing... 1GB per day basis at 2011-01-11 18:11:12 from Karayappalli, Raghunath (Raghu)

Browse pgsql-general by date

	From	Date	Subject
Next Message	Craig Ringer	2011-01-11 10:29:51	Re: migrate hashname function from 8.1.x to 8.4
Previous Message	Craig Ringer	2011-01-11 09:59:38	Re: Mixed client_encoding database question