Re: Postgres hangs during VACUUM (autocommit = false)

"Mark Coffman \(Epilogue Programmer\)" <mark@epilogue.net> writes:
> Thanks for the reply.  I use Perl and DBI to make my database conneciton.
> In the

> BEGIN {}
> part of the module, I check for the persistant connection, and make one if
> none is present, autocommit off
> in the
> END {}
> block, I do a $dbh->commit();

Hmm.  I wonder whether "autocommit off" does what you think it does;
it may be that you want the exact opposite.

You might want to turn on query logging and see just what the clients
are sending.

            regards, tom lane