Re: autovacuum and TOAST tables

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: autovacuum and TOAST tables
Дата
Msg-id 26673.1218737722@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: autovacuum and TOAST tables  (Alvaro Herrera <alvherre@commandprompt.com>)
Ответы Re: autovacuum and TOAST tables
Список 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 по дате отправления:

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: autovacuum and TOAST tables
Следующее
От: Tom Lane
Дата:
Сообщение: Re: WIP: patch to create explicit support for semi and anti joins