| From: | Alan Hodgson <ahodgson(at)simkin(dot)ca> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Vacuum and Reindex hangs |
| Date: | 2009-01-15 20:17:16 |
| Message-ID: | 200901151217.16463@hal.medialogik.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Thursday 15 January 2009, Jason Long <mailing(dot)list(at)supernovasoftware(dot)com>
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.
Obviously it is affecting it and it is taking longer than 2 minutes
regardless of how long you think it "should take". Set it higher for these
tasks or buy a faster server.
--
Current Peeve: The mindset that the Internet is some sort of school for
novice sysadmins and that everyone -not- doing stupid dangerous things
should act like patient teachers with the ones who are. -- Bill Cole, NANAE
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Joshua D. Drake | 2009-01-15 20:21:22 | Re: Vacuum and Reindex hangs |
| Previous Message | Joshua D. Drake | 2009-01-15 20:14:20 | Re: Vacuum and Reindex hangs |