Re: selects during vacuum

From: Richard Huxton <dev(at)archonet(dot)com>
To: Joe Maldonado <jmaldonado(at)webehosting(dot)biz>, pgsql-general(at)postgresql(dot)org
Subject: Re: selects during vacuum
Date: 2003-07-15 20:35:21
Message-ID: 200307152135.21222.dev@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Richard Huxton 2003-07-15 20:41:19 Re: Fw: select null + 0 question
Previous Message Joe Maldonado 2003-07-15 20:33:23 Re: selects during vacuum