Re: best way to run maintenance script

From: Vinubalaji Gopal <vgopal(at)abaca(dot)com>
To: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
Cc: "Pgsql-Performance ((E-mail))" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: best way to run maintenance script
Date: 2008-03-15 01:51:52
Message-ID: 1205545912.12661.22.camel@vinu-ubuntu.abaca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Hi Joshua,

> You can use parameters such as vacuum_cost_delay to help this... see
> the docs:
>
> http://www.postgresql.org/docs/8.3/static/runtime-config-autovacuum.html

I am checking it out. Seems to be a nice option for vacuum - but wish
there was a way to change the delete priority or I will try to use the C
based priority hack.

> If you are truly running 8.0 and not something like 8.0.15 vacuum is
> the least of your worries.
Its 8.0.4.

Thanks.

--
Vinu

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Joshua D. Drake 2008-03-15 02:17:22 Re: best way to run maintenance script
Previous Message Tom Lane 2008-03-15 01:37:22 Re: best way to run maintenance script