Re: [HACKERS] select * from ..;vacuum crashes

Поиск
Список
Период
Сортировка
От Vadim Mikheev
Тема Re: [HACKERS] select * from ..;vacuum crashes
Дата
Msg-id 3619BDEF.C15A48EE@krs.ru
обсуждение исходный текст
Ответ на RE: [HACKERS] select * from ..;vacuum crashes  ("Taral" <taral@mail.utexas.edu>)
Список pgsql-hackers
Taral wrote:
>
> > begin;
> > select * from getting;
> > vacuum;
> > end;
>
> Question: Does the following really make sense?
>
> begin transaction;
> select * from table;
> vacuum;
> abort transaction;

Using vacuum inside BEGIN/END is Bad Idea!!!
MUST be disabled: vacuum uses MANY transaction but
CommitTransactionCommand() used by vacuum does nothing
inside BEGIN/END (only increments command counter).

Vadim

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

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: [HACKERS] select * from ..;vacuum crashes
Следующее
От: Frank Ridderbusch
Дата:
Сообщение: Portability Issue in src/backend/port/snprintf.c (I think)