Re: autovacuum and TOAST tables

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: autovacuum and TOAST tables
Дата
Msg-id 20080812010608.GI8416@alvh.no-ip.org
обсуждение исходный текст
Ответ на Re: autovacuum and TOAST tables  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
Tom Lane wrote:

> On second thought, I think it *could* lead to a visible failure.
> Suppose the OID counter wraps around and the OID that had been used for
> the temporary CLUSTER table gets assigned to a new table.  If that table
> needs a toast table, it'll try to create one using the name that is
> already in use.  We have defenses against picking an OID that's in use,
> but none for toast table names.  So I think it's indeed worth fixing.

Okay, I'll see to it after committing this autovacuum stuff.

-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: autovacuum and TOAST tables
Следующее
От: Casey Duncan
Дата:
Сообщение: Re: Mini improvement: statement_cost_limit