Re: handling TOAST tables in autovacuum

From: Euler Taveira de Oliveira <euler(at)timbira(dot)com>
To: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
Cc: Pg Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: handling TOAST tables in autovacuum
Date: 2008-06-09 02:03:27
Message-ID: 484C8F6F.5090102@timbira.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Alvaro Herrera wrote:

> We've been making noises about dealing with TOAST tables as separate
> entities in autovacuum for some time now. So here's a proposal:
>
Let's keep it simple. Why not just adding a toast_enabled flag (disabled
by default) in pg_autovacuum? If it's set then main and toast tables are
processed by autovac.

FYI, I have a WIP patch to remove pg_autovacuum in favor of reloptions.
And based on your proposal, it'll be needed to add reloptions to toast
tables too. IMO, we should keep that code as simple as possible.

--
Euler Taveira de Oliveira
http://www.timbira.com/

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Marc G. Fournier 2008-06-09 02:03:47 Re: [CORE] Automating our version-stamping a bit better
Previous Message Tom Lane 2008-06-09 01:27:03 Re: Automating our version-stamping a bit better