Re: Autovacuum in the backend

From: Neil Conway <neilc(at)samurai(dot)com>
To: Josh Berkus <josh(at)agliodbs(dot)com>
Cc: Gavin Sherry <swm(at)linuxworld(dot)com(dot)au>, Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Autovacuum in the backend
Date: 2005-06-16 04:08:20
Message-ID: 42B0FB34.5050809@samurai.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

Josh Berkus wrote:
> Not that I don't agree that we need a less I/O intense alternative to VACUUM,
> but it seems unlikely that we could actually do this, or even agree on a
> spec, before feature freeze.

I don't see the need to rush anything in before the feature freeze.

> Wheras integrated AV is something we *could* do, and is widely desired.

I don't see why. IMHO the current autovacuum approach is far from
optimal. If "integrated autovacuum" just means taking the same approach
and building it into the backend, how does that significantly improve
matters? (I find it difficult to take seriously answers like "it lets us
use the backend's hash table implementation"). It _does_ mean there is
more of an implicit stamp of PGDG approval for pg_autovacuum, which is
something I personally wouldn't want to give to the current design.

-Neil

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Neil Conway 2005-06-16 04:09:47 Re: Autovacuum in the backend
Previous Message Josh Berkus 2005-06-16 04:07:30 Re: Autovacuum in the backend

Browse pgsql-hackers by date

  From Date Subject
Next Message Neil Conway 2005-06-16 04:09:47 Re: Autovacuum in the backend
Previous Message Josh Berkus 2005-06-16 04:07:30 Re: Autovacuum in the backend