| From: | "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com> |
|---|---|
| To: | Jason Long <mailing(dot)list(at)supernovasoftware(dot)com> |
| Cc: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Vacuum and Reindex hangs |
| Date: | 2009-01-15 20:14:20 |
| Message-ID: | 1232050460.12600.231.camel@jd-laptop.pragmaticzealot.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Thu, 2009-01-15 at 14:06 -0600, Jason Long wrote:
> I am attempting to vacuum and reindex my database. It keeps timing
> out. See commands and last part of output below. The vacuum or
> reindex only takes a short time to complete normally because the
> database it less than 50 mb. I have the query timeout set to 2
> minutes, but I do not know if this can affect vacuumdb or reindexdb
> and the time should take much less than 2 minutes anyway.
>
> I am using 8.3.3 on Centos 5.
You have statement_timeout set. You can use SET in psql to change
this....
SET statement_timeout TO ...
Joshua D. Drake
--
PostgreSQL - XMPP: jdrake(at)jabber(dot)postgresql(dot)org
Consulting, Development, Support, Training
503-667-4564 - http://www.commandprompt.com/
The PostgreSQL Company, serving since 1997
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alan Hodgson | 2009-01-15 20:17:16 | Re: Vacuum and Reindex hangs |
| Previous Message | Raymond O'Donnell | 2009-01-15 20:13:08 | Re: Vacuum and Reindex hangs |