From: | Jason Long <mailing(dot)list(at)supernovasoftware(dot)com> |
---|---|
To: | Alan Hodgson <ahodgson(at)simkin(dot)ca> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Vacuum and Reindex hangs |
Date: | 2009-01-15 20:28:54 |
Message-ID: | 496F9C86.8090701@supernovasoftware.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Alan Hodgson wrote:
> 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.
>
>
A faster server.
Well the sever is plenty fast. It has 2 quad core 1600MHz FSB 3.0 GHz
Xeon 5472 CPUs and a very light workload.
My statement about the time is that it has never taken that long.
Ever. Not even close.
I will increase the setting and see if that works.
From | Date | Subject | |
---|---|---|---|
Next Message | Jason Long | 2009-01-15 20:32:22 | Re: Vacuum and Reindex hangs |
Previous Message | Kirk Strauser | 2009-01-15 20:26:04 | Re: Why would I want to use connection pooling middleware? |