Re: Second attempt, roll your own autovacuum

From: Csaba Nagy <nagy(at)ecircle-ag(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Glen Parker <glenebob(at)nwlink(dot)com>, Postgres general mailing list <pgsql-general(at)postgresql(dot)org>
Subject: Re: Second attempt, roll your own autovacuum
Date: 2006-12-19 09:27:10
Message-ID: 1166520430.13028.203.camel@coppola.muc.ecircle.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

On Tue, 2006-12-19 at 07:28, Tom Lane wrote:
> Glen Parker <glenebob(at)nwlink(dot)com> writes:
> > I am still trying to roll my own auto vacuum thingy.
>
> Um, is this purely for hack value? What is it that you find inadequate
> about regular autovacuum? It is configurable through the pg_autovacuum
> catalog --- which I'd be the first to agree is a sucky user interface,
> but we're not going to set the user interface in concrete until we are
> pretty confident it's feature-complete. So: what do you see missing?

I'm not sure what the OP had in mind, but the thing which is missing for
us is a time window restriction sort of thing. What I mean is to make
sure a vacuum will never kick in in the main business hours, but only at
night at pre-specified hours, and only if the vacuum threshold was met
for the delete/update counts.

It would be nice if there could be a flexible time window specification,
like specifying only some days, or only weekends, or each night some
specific hours... but just one time window would be a big improvement
already.

Cheers,
Csaba.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Hannes Dorbath 2006-12-19 09:28:07 Help compile pgmemcache against PG 8.2
Previous Message Magnus Hagander 2006-12-19 09:02:49 Re: Let's play bash the search engine

Browse pgsql-hackers by date

  From Date Subject
Next Message ITAGAKI Takahiro 2006-12-19 09:31:27 Re: Load distributed checkpoint
Previous Message ITAGAKI Takahiro 2006-12-19 09:17:10 Load distributed checkpoint patch