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

From Alvaro Herrera
Subject Re: handling TOAST tables in autovacuum
Date
Msg-id 20080609021912.GD11493@alvh.no-ip.org
Whole thread Raw
In response to Re: handling TOAST tables in autovacuum  (Euler Taveira de Oliveira <euler@timbira.com>)
Responses Re: handling TOAST tables in autovacuum  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Euler Taveira de Oliveira wrote:

> FYI, I have a WIP patch to remove pg_autovacuum in favor of reloptions.  

Really?  Please send it my way to review/apply as soon as you have it
ready, independently of what we do with toast tables.

> 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.

Actually I think your proposal is more cumbersome to use and less
flexible, because you can't set specific values for the other options
for toast tables.

> 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.

Sure, what's the problem with that?  We only need to make sure that
ALTER TABLE works for setting reloptions for toast tables.

-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.


pgsql-hackers by date:

Previous
From: "Marc G. Fournier"
Date:
Subject: Re: [CORE] Automating our version-stamping a bit better
Next
From: Andrew Chernow
Date:
Subject: Re: libpq support for arrays and composites