Re: Simple thing to make pg_autovacuum more useful

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On Thu, 17 Jan 2008 20:34:07 -0500
Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> Gregory Stark <stark(at)enterprisedb(dot)com> writes:
> > Are you picturing adding ALTER TABLE commands to set autovacuum
> > parameters?
>
> Well, as I said, I was trying to think of an appropriate user-visible
> API, which I didn't think that pg_autovacuum itself could become.
>
> Further downthread Alvaro points out that we've already had that
> discussion, and exploiting the reloptions infrastructure was agreed
> to be a reasonable solution. It took a bit of searching to find
> that thread, but here it is:
> http://archives.postgresql.org/pgsql-hackers/2007-02/msg01440.php

Interesting. O.k. I must admit that I would sure rather use ALTER TABLE
to do this than INSERT, SELECT. Let's not lose sight that we still need
to be able to manage large sets of relations though.

We need to make sure there is a readily available way to retrieve the
data as well.

Sincerely,

Joshua D. Drake
- --
The PostgreSQL Company: Since 1997, http://www.commandprompt.com/
Sales/Support: +1.503.667.4564 24x7/Emergency: +1.800.492.2240
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
SELECT 'Training', 'Consulting' FROM vendor WHERE name = 'CMD'

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)

iD8DBQFHkBrAATb/zqfZUUQRApUHAJ9MvS3pcZAa2ix+8pCrmGQ4G1VdiQCaA+44
YwbncnAmby4pzCZqnRn6ANM=
=cbaq
-----END PGP SIGNATURE-----