Postgres Pro
Downloads
Home   >   mailing lists

selects during vacuum - Mailing list pgsql-general

From Joe Maldonado
Subject selects during vacuum
Date
Msg-id 1058299765.3340.8.camel@joem
Whole thread Raw
Responses Re: selects during vacuum  ("Nigel J. Andrews" <nandrews@investsystems.co.uk>)
Re: selects during vacuum  (Andrew Sullivan <andrew@libertyrms.info>)
Re: selects during vacuum  ("scott.marlowe" <scott.marlowe@ihs.com>)
Re: selects during vacuum  (Richard Huxton <dev@archonet.com>)
Re: selects during vacuum  (Alvaro Herrera <alvherre@dcc.uchile.cl>)
List pgsql-general
Tree view 
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...

-Joe

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: [BUGS] INSTEAD rule bug?
Next
From: Florian Weimer
Date:
Subject: Re: IPv4 addresses, unsigned integers, space