From: | "Nigel J(dot) Andrews" <nandrews(at)investsystems(dot)co(dot)uk> |
---|---|
To: | Joe Maldonado <jmaldonado(at)webehosting(dot)biz> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: selects during vacuum |
Date: | 2003-07-15 20:23:27 |
Message-ID: | Pine.LNX.4.21.0307152121370.20776-100000@ponder.fairway2k.co.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 15 Jul 2003, 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...
>
You probably need to question why the vacuum analyse is taking a long time on a
small table. Not because it isn't annoying for your selects to appear to hang
but because it shouldn't take a long time to analyze a small table so there's
probably something more significant wrong than slow/blocked queries.
--
Nigel J. Andrews
From | Date | Subject | |
---|---|---|---|
Next Message | Andrew Sullivan | 2003-07-15 20:23:59 | Re: selects during vacuum |
Previous Message | Dmitry Tkach | 2003-07-15 20:17:24 | Re: [GENERAL] INSTEAD rule bug? |