Re: handling TOAST tables in autovacuum - Mailing list pgsql-hackers

From Euler Taveira de Oliveira
Subject Re: handling TOAST tables in autovacuum
Date
Msg-id 484C8F6F.5090102@timbira.com
Whole thread Raw
In response to handling TOAST tables in autovacuum  (Alvaro Herrera <alvherre@commandprompt.com>)
Responses Re: handling TOAST tables in autovacuum  (Alvaro Herrera <alvherre@commandprompt.com>)
List 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/



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Automating our version-stamping a bit better
Next
From: "Marc G. Fournier"
Date:
Subject: Re: [CORE] Automating our version-stamping a bit better