Re: selects during vacuum

From: "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com>
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:15:46
Message-ID: Pine.LNX.4.33.0307151415340.27746-100000@css120.ihs.com
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...

What version of postgresql are you running?

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message scott.marlowe 2003-07-15 20:16:57 Re: perfromance impact of vacuum
Previous Message Florian Weimer 2003-07-15 20:12:13 Re: IPv4 addresses, unsigned integers, space