Re: selects during vacuum

On Tue, Jul 15, 2003 at 04:09:28PM -0400, Joe Maldonado wrote:
> Hello,
> Vacuum analyze is taking a really long time on a fairly small table and
> during the time the vacuum is running all "select * from <the table>;"
> seems to hang untill the vacuum is done. Any help on this matter would
> be greatly appreciated...

If you're running Postgres < 7.2, then vacuum blocks. And it's
probably waiting for a different transaction to finish before it
proceeds, which means everything is blocked. Alternatively, if
you've actually run VACUUM FULL, you get the same behaviour.

A

--
----
Andrew Sullivan 204-4141 Yonge Street
Liberty RMS Toronto, Ontario Canada
<andrew(at)libertyrms(dot)info> M2P 2A8
+1 416 646 3304 x110