From: Scott Marlowe <scott.marlowe@gmail.com>
To: Jonah H. Harris <jonah.harris@gmail.com>
Cc: Joshua D. Drake <jd@commandprompt.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Campbell, Lance <lance@uiuc.edu>
Cc: posgres support <pgsql-admin@postgresql.org>
Subject: Re: Enhancement request
Date: Fri, 30 Nov 2007 21:20:40 -0600
Message-ID: <dcc563d10711301920g19c7deads732cd6044d636b8e@mail.gmail.com> (raw)
In-Reply-To: <36e682920711301453x2d361iff5d3f8679606d3e@mail.gmail.com>
References: <B10E6810AC2A2F4EA7550D072CDE8760197E2C@SAB-FENWICK.sab.uiuc.edu>
<36e682920711301218m703b3c67s6f547fd7b9b60e7c@mail.gmail.com>
<7099.1196458205@sss.pgh.pa.us>
<36e682920711301332q1cce5db9qe44fb068fcd5608d@mail.gmail.com>
<7341.1196459304@sss.pgh.pa.us>
<20071130140005.18521c54@jd-laptop>
<36e682920711301453x2d361iff5d3f8679606d3e@mail.gmail.com>
On Nov 30, 2007 4:53 PM, Jonah H. Harris <jonah.harris@gmail.com> wrote:
> On Nov 30, 2007 5:00 PM, Joshua D. Drake <jd@commandprompt.com> wrote:
> > > So: show me a use case for this that will still make sense in a
> > > mostly-autovacuum world.
> >
> > I think you are living in a different world than I am if you think it
> > is a mostly-autovacuum world.
>
> Same here.
>
> > Yes autovacuum is great for general low use scenarios. Throw it at a
> > database doing hundreds of thousands (or even millions) of transactions
> > an hour that has relations that in the multiple hundred gig range and
> > autovacuum is useless for a good portion of that database.
>
> Yes, this is precisely the case I'm talking about. Every single
> high-volume client we have or have consulted for is using custom
> vacuuming. Autovacuum works fine for the common case, but it doesn't
> handle high-volume databases very well yet.
That's the case today, because autovacuum is single threaded and can't
hit >1 table at once, so a single very large table vacuum could allow
other, smaller tables to bloat inordinately.
Which is why 8.3 can vacuum > 1 table at a time.
I'm not against having a schema keyword mind you, I'm just pointing
out that the ultimate goal of the hackers seems to be an autovacuum
daemon that can keep the database vacuumed without the need for user
initiated vacuums at all.
Not sure 8.3 will get us there. But the multi-threaded autovac is a
darn good start.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: scott.marlowe@gmail.com, jonah.harris@gmail.com, jd@commandprompt.com, tgl@sss.pgh.pa.us, lance@uiuc.edu
Subject: Re: Enhancement request
In-Reply-To: <dcc563d10711301920g19c7deads732cd6044d636b8e@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox