Re: [HACKERS] Autovacuum Improvements

From: elein <elein(at)varlena(dot)com>
To: Simon Riggs <simon(at)2ndquadrant(dot)com>, Pavan Deolasee <pavan(at)enterprisedb(dot)com>, Christopher Browne <cbbrowne(at)acm(dot)org>, pgsql-general(at)postgresql(dot)org, pgsql-hackers(at)postgresql(dot)org
Cc: elein <elein(at)varlena(dot)com>
Subject: Re: [HACKERS] Autovacuum Improvements
Date: 2007-01-14 00:05:43
Message-ID: 20070114000543.GC8879@varlena.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

On Fri, Jan 12, 2007 at 07:33:05PM -0300, Alvaro Herrera wrote:
> Simon Riggs wrote:
>
> > Some feedback from initial testing is that 2 queues probably isn't
> > enough. If you have tables with 100s of blocks and tables with millions
> > of blocks, the tables in the mid-range still lose out. So I'm thinking
> > that a design with 3 queues based upon size ranges, plus the idea that
> > when a queue is empty it will scan for tables slightly above/below its
> > normal range.
>
> Yeah, eventually it occurred to me the fact that as soon as you have 2
> queues, you may as well want to have 3 or in fact any number. Which in
> my proposal is very easily achieved.
>
>
> > Alvaro, have you completed your design?
>
> No, I haven't, and the part that's missing is precisely the queues
> stuff. I think I've been delaying posting it for too long, and that is
> harmful because it makes other people waste time thinking on issues that
> I may already have resolved, and delays the bashing that yet others will
> surely inflict on my proposal, which is never a good thing ;-) So maybe
> I'll put in a stub about the "queues" stuff and see how people like the
> whole thing.

Have you made any consideration of providing feedback on autovacuum to users?
Right now we don't even know what tables were vacuumed when and what was
reaped. This might actually be another topic.

---elein
elein(at)varlena(dot)com

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Devrim GUNDUZ 2007-01-14 00:05:54 Re: installing 8.2 on solaris 10?
Previous Message Jeff Amiel 2007-01-13 17:40:41 Re: Corrupt database? 8.1/FreeBSD6.0

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2007-01-14 00:14:52 Re: Memory context in exception handler
Previous Message Jignesh Shah 2007-01-13 23:38:24 Performance of Parser?