Re: autovacuum and TOAST tables

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: autovacuum and TOAST tables
Дата
Msg-id 20081011001456.GI4194@alvh.no-ip.org
обсуждение исходный текст
Ответ на Re: autovacuum and TOAST tables  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
Tom Lane wrote:
> Alvaro Herrera <alvherre@commandprompt.com> writes:
> >> Yeah, that seems like the best answer.
>
> > Seems like this patch fixes it.
>
> Um, not for tables that don't have toast tables ...

Right, this seems better.

Note that it needs to open the toast table and grab AccessShare to get
the toast index OID.  I don't think it needs a stronger lock.

--
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

Вложения

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: Contrib, schema, and load_module
Следующее
От: "Nikolas Everett"
Дата:
Сообщение: Re: How is random_page_cost=4 ok?