| 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: | Whole Thread | Raw Message | 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? |