| From: | Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl> |
|---|---|
| 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:52:21 |
| Message-ID: | 20030715205221.GE9410@dcc.uchile.cl |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Tue, Jul 15, 2003 at 04:09:28PM -0400, Joe Maldonado wrote:
> 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...
Try to reindex the table. That should speed up the vacuuming.
--
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
You liked Linux a lot when he was just the gawky kid from down the block
mowing your lawn or shoveling the snow. But now that he wants to date
your daughter, you're not so sure he measures up. (Larry Greenemeier)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | scott.marlowe | 2003-07-15 20:56:31 | This whole MySQL versus PGSQL thing |
| Previous Message | Richard Huxton | 2003-07-15 20:41:19 | Re: Fw: select null + 0 question |