Re: Autovacuum in postgres. - Mailing list pgsql-performance

From Scott Marlowe
Subject Re: Autovacuum in postgres.
Date
Msg-id AANLkTinamjCzg2L6F1jtK0Ukx02BjItDP7bOOyXgDQUP@mail.gmail.com
Whole thread Raw
In response to Re: Autovacuum in postgres.  (venu madhav <venutaurus539@gmail.com>)
List pgsql-performance
On Thu, May 27, 2010 at 9:01 AM, venu madhav <venutaurus539@gmail.com> wrote:
> Thanks for the reply..
>            I am using postgres 8.01 and since it runs on a client box, I
> can't upgrade it. I've set the auto vacuum nap time to 3600 seconds.

You've pretty much made autovac run every 5 hours with that setting.
What was wrong with the original settings?  Just wondering what
problem you were / are trying to solve here.

pgsql-performance by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: How to insert a bulk of data with unique-violations very fast
Next
From: "Kevin Grittner"
Date:
Subject: Re: requested shared memory size overflows size_t