On Thursday 15 January 2009, Jason Long <mailing.l...@supernovasoftware.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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
