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

From Tom Lane
Subject Re: handling TOAST tables in autovacuum
Date
Msg-id 5138.1212981006@sss.pgh.pa.us
Whole thread Raw
In response to Re: handling TOAST tables in autovacuum  (Alvaro Herrera <alvherre@commandprompt.com>)
List pgsql-hackers
Alvaro Herrera <alvherre@commandprompt.com> writes:
> Euler Taveira de Oliveira wrote:
>> 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.

... actually, the problem is going to be "how do you get pg_dump to dump
and reload such settings"?  The toast tables are not going to have the
same names after dump/reload.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Andrew Chernow
Date:
Subject: Re: libpq support for arrays and composites
Next
From: Andrew Dunstan
Date:
Subject: Re: libpq support for arrays and composites