Quick Links

selects during vacuum

From:	Joe Maldonado <jmaldonado(at)webehosting(dot)biz>
To:	pgsql-general(at)postgresql(dot)org
Subject:	selects during vacuum
Date:	2003-07-15 20:09:28
Message-ID:	1058299765.3340.8.camel@joem
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	pgsql-general

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

Responses

Re: selects during vacuum at 2003-07-15 20:15:46 from scott.marlowe
Re: selects during vacuum at 2003-07-15 20:23:27 from Nigel J. Andrews
Re: selects during vacuum at 2003-07-15 20:23:59 from Andrew Sullivan
Re: selects during vacuum at 2003-07-15 20:35:21 from Richard Huxton
Re: selects during vacuum at 2003-07-15 20:52:21 from Alvaro Herrera

Browse pgsql-general by date

	From	Date	Subject
Next Message	Florian Weimer	2003-07-15 20:12:13	Re: IPv4 addresses, unsigned integers, space
Previous Message	Tom Lane	2003-07-15 20:05:44	Re: [GENERAL] INSTEAD rule bug?