Re: [HACKERS] Vacuum analyze bug CAUGHT

Поиск
Список
Период
Сортировка
От Vadim Mikheev
Тема Re: [HACKERS] Vacuum analyze bug CAUGHT
Дата
Msg-id 37D8AA16.8F767392@krs.ru
обсуждение исходный текст
Ответ на RE: [HACKERS] Vacuum analyze bug CAUGHT  ("Hiroshi Inoue" <Inoue@tpf.co.jp>)
Ответы RE: [HACKERS] Vacuum analyze bug CAUGHT  ("Hiroshi Inoue" <Inoue@tpf.co.jp>)
Список pgsql-hackers
Hiroshi Inoue wrote:
> 
> > crashtest=> vacuum analyze;
> > NOTICE:  Rel pg_type: TID 4/3: InsertTransactionInProgress 129915
> > - can't shrink relation
...
> 
> CREATE TABLE doesn't lock system tables till end of transaction.
> It's a cause of these NOTICE messages.
> 
> Should we lock system tables till end of transaction ?

No, if we allow DDL statements inside BEGIN/END
(in long transaction).

> Moreover CREATE TABLE doesn't acquire any lock for pg_attribute
>                             ^^^^^^^^^^^^^^^^^^^^^^^^^^^^
> while tuples are inserted into pg_attribute.
> Concurrent vacuum may corrupt pg_attribute.

Should be fixed!

Vadim


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

Предыдущее
От: "Hiroshi Inoue"
Дата:
Сообщение: RE: [HACKERS] Vacuum analyze bug CAUGHT
Следующее
От: "Hiroshi Inoue"
Дата:
Сообщение: RE: [HACKERS] Vacuum analyze bug CAUGHT