Re: Postgres hangs during VACUUM (autocommit = false)

"Mark Coffman \(Epilogue Programmer\)" <mark(at)epilogue(dot)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