Re: selects during vacuum - Mailing list pgsql-general

From Richard Huxton
Subject Re: selects during vacuum
Date
Msg-id 200307152135.21222.dev@archonet.com
Whole thread Raw
In response to selects during vacuum  (Joe Maldonado <jmaldonado@webehosting.biz>)
Responses Re: selects during vacuum  (Joe Maldonado <jmaldonado@webehosting.biz>)
List pgsql-general
On Tuesday 15 Jul 2003 9:09 pm, 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...

Can you post the output of a "verbose" vacuum analyse? That will tell us what
it's up to.

--
  Richard Huxton

pgsql-general by date:

Previous
From: Joe Maldonado
Date:
Subject: Re: selects during vacuum
Next
From: Richard Huxton
Date:
Subject: Re: Fw: select null + 0 question