Re: selects during vacuum

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

In response to

Browse pgsql-general by date

  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?