Re: selects during vacuum

From: Joe Maldonado <jmaldonado(at)webehosting(dot)biz>
To: "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: selects during vacuum
Date: 2003-07-15 20:33:23
Message-ID: 1058301200.3340.10.camel@joem
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Sorry forgot to mention we are running postgres 7.2.3.

-Joe
On Tue, 2003-07-15 at 16:15, scott.marlowe wrote:
> 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

Browse pgsql-general by date

  From Date Subject
Next Message Richard Huxton 2003-07-15 20:35:21 Re: selects during vacuum
Previous Message Darko Prenosil 2003-07-15 20:31:03 Re: Install new language - Prev: Re: Are you frustrated with PostgreSQL