Skip site navigation (1) Skip section navigation (2)

Re: pg_autovacuum should allow NULL values

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
Cc: Mark Stosberg <mark(at)summersault(dot)com>, pgsql-general(at)postgresql(dot)org, pgsql-hackers(at)postgresql(dot)org
Subject: Re: pg_autovacuum should allow NULL values
Date: 2007-02-23 23:47:52
Message-ID: 8816.1172274472@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-hackers
I wrote:
> I don't find this particularly important, because we have never intended
> direct update of catalog entries to be a primary way of interacting with
> the system.  The current pg_autovacuum setup is a stopgap until the dust
> has settled enough that we know what sort of long-term API we want for
> autovacuum.

I just had an epiphany about that.  We've wanted to avoid setting the
autovacuum knobs in stone, because it's pretty obvious they're not
ready, and that has prevented us from inventing any nice SQL syntax for
managing the per-table settings.

Meanwhile, the storage-parameter infrastructure got added in 8.2.
Isn't that an absolutely ideal framework for managing per-table autovac
settings?  We could drop the separate pg_autovacuum catalog altogether
and keep all the info in pg_class.reloptions.  Advantages:

* The infrastructure is all there already, including ALTER TABLE and
pg_dump support.

* The parameter names are not SQL keywords, and the syntax isn't
hardwired to any particular set of them.  So it would be fairly painless
to change the set of supported parameters, with or without backwards
compatibility to keep on recognizing an old parameter.

Disadvantages:

* Wouldn't be forwards-compatible with any hacks that people might
currently have to dump and restore pg_autovacuum contents.  But you
could probably make a script to read your existing table and emit
ALTER TABLE SET commands instead.

			regards, tom lane

In response to

Responses

pgsql-hackers by date

Next:From: Lukas Kahwe SmithDate: 2007-02-23 23:49:32
Subject: Re: 5 Weeks till feature freeze or (do you know where your patch is?)
Previous:From: Warren TurkalDate: 2007-02-23 23:44:40
Subject: developer wiki (was Re: SCMS question)

pgsql-general by date

Next:From: Lukas Kahwe SmithDate: 2007-02-23 23:49:32
Subject: Re: 5 Weeks till feature freeze or (do you know where your patch is?)
Previous:From: Ed L.Date: 2007-02-23 23:38:30
Subject: Re: db stats vs table stats

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group