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@libertyrms.info>                              M2P 2A8
                                         +1 416 646 3304 x110