Re: [HACKERS] select * from ..;vacuum crashes - Mailing list pgsql-hackers

From Vadim Mikheev
Subject Re: [HACKERS] select * from ..;vacuum crashes
Date
Msg-id 3619BDEF.C15A48EE@krs.ru
Whole thread Raw
In response to RE: [HACKERS] select * from ..;vacuum crashes  ("Taral" <taral@mail.utexas.edu>)
List 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 by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: [HACKERS] select * from ..;vacuum crashes
Next
From: Frank Ridderbusch
Date:
Subject: Portability Issue in src/backend/port/snprintf.c (I think)