On 01/12/2011 01:37 AM, Karayappalli, Raghunath (Raghu) wrote:
I am using the version 8.2.
I have enabled auto vacuum (assuming that you are referring to the
"autovacuum = on" configuration).
Autovacuum improves significantly with every Pg release. 8.3 and 8.4
both saw quite big improvements.
Dne 11.1.2011 19:11, Karayappalli, Raghunath (Raghu) napsal(a):
> I am missing some of your questions: what are the tuning parameters are
> you referring here that would prevent running auto vacuum?
There is a bunch of parameters influencing autovacuum - how often it
runs, how much work it does, e
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-
rayappalli, 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.
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' s
Hello, my name is raghu. I work for Avaya. We uses postgres as database
in our application. Our application is a jboss based enterprise
application, that does some updates operations based on requests from
client. We use entities and hibernate for data access within our
application.
I have coup
