Re: Simple thing to make pg_autovacuum more useful

From: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Simple thing to make pg_autovacuum more useful
Date: 2008-01-17 22:31:08
Message-ID: 20080117143108.0a882de3@commandprompt.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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

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

> "Joshua D. Drake" <jd(at)commandprompt(dot)com> writes:
> > Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> > There are two things here. One having a default value 8.2 currently
> > doesn't
>
> I'm not really convinced by this argument. pg_autovacuum was never
> designed to be user-friendly; it is designed to be the back end
> storage for something that *is* user-friendly (which we have not got
> yet). I would say that smarts about defaults ought to go into
> whatever code you are creating that inserts into pg_autovacuum.

My insert statements don't agree ;).

I can type it, I can script it. It's not that big of a deal but
consider what I am asking provides only a positive return that isn't
out of line with the scope of autovacuum configuration in general.

Your objection is let's keep it as difficult as possible within the
existing paradigm because nobody thought pg_autovacuum could be useful
in the first place.

That seems incorrect to me as we continue to have people that are going
to need to use pg_autovacuum.

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)

iD8DBQFHj9csATb/zqfZUUQRAlpAAJ4lJcj2pqqaAVz+x8SD6DpKH3cWUgCgiAfL
edr2JA2sl72rzH2ogGHxpy8=
=9FO8
-----END PGP SIGNATURE-----

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2008-01-17 22:38:57 Re: Simple thing to make pg_autovacuum more useful
Previous Message Kevin Grittner 2008-01-17 22:25:36 Re: OUTER JOIN performance regression remains in 8.3beta4