Re: handling TOAST tables in autovacuum

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.