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

Vadim Mikheev <vadim@krs.ru>

From: Vadim Mikheev <vadim@krs.ru>
To: Taral <taral@mail.utexas.edu>
Cc: t-ishii@sra.co.jp, pgsql-hackers@postgreSQL.org
Date: 1998-10-06T06:51:27Z
Lists: 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