Re: autovacuum and TOAST tables - Mailing list pgsql-hackers

From Tom Lane
Subject Re: autovacuum and TOAST tables
Date
Msg-id 26673.1218737722@sss.pgh.pa.us
Whole thread Raw
In response to Re: autovacuum and TOAST tables  (Alvaro Herrera <alvherre@commandprompt.com>)
Responses Re: autovacuum and TOAST tables  (Alvaro Herrera <alvherre@commandprompt.com>)
List pgsql-hackers
Alvaro Herrera <alvherre@commandprompt.com> writes:
> My first attempt at a fix, which was simply swapping relfilenode for the
> TOAST tables (and its indexes) after the data has been copied, does not
> work, apparently because the TOAST pointers have the toast table ID
> embedded.

Ouch.  Right.

> I wonder if we can get away with simply renaming the new toast table and
> index after the data has been copied.

Yeah, that seems like the best answer.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: autovacuum and TOAST tables
Next
From: Tom Lane
Date:
Subject: Re: WIP: patch to create explicit support for semi and anti joins