Re: Vacuum and Reindex hangs

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@jabber.postgresql.org
   Consulting, Development, Support, Training
   503-667-4564 - http://www.commandprompt.com/
   The PostgreSQL Company, serving since 1997