| From: | Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> |
|---|---|
| To: | venu madhav <venutaurus539(at)gmail(dot)com> |
| Cc: | Bruce Momjian <bruce(at)momjian(dot)us>, pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: Autovacuum in postgres. |
| Date: | 2010-06-02 20:12:15 |
| Message-ID: | AANLkTinamjCzg2L6F1jtK0Ukx02BjItDP7bOOyXgDQUP@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
On Thu, May 27, 2010 at 9:01 AM, venu madhav <venutaurus539(at)gmail(dot)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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jori Jovanovich | 2010-06-02 20:28:54 | SELECT ignoring index even though ORDER BY and LIMIT present |
| Previous Message | Scott Marlowe | 2010-06-02 19:59:23 | Re: How to insert a bulk of data with unique-violations very fast |