Re: Power cut and performance problem - Mailing list pgsql-sql

From Jeff Frost
Subject Re: Power cut and performance problem
Date
Msg-id Pine.LNX.4.64.0603201551360.18416@discord.dyndns.org
Whole thread Raw
In response to Re: Power cut and performance problem  ("Daniel Caune" <daniel.caune@ubisoft.com>)
List pgsql-sql
On Mon, 20 Mar 2006, Daniel Caune wrote:

>> I see you're running autovacuum.  What's your disk subsytem look like?
> By
>> chance is it sitting on a RAID 5 that's running in degraded mode right
> now
>> while it scrubs?
>>
>
> Yes, that should be the problem.  I will check that tomorrow morning
> with a Linux administrator.  Thanks.

BTW, I didn't complete my first thought above, which was to ask when you last 
vacuumed the DB, but then I saw that you were running autovac, so that wasn't 
likely the problem.

BTW, if the problem is actually a raid array that is rebuilding, it should be 
(hopefullY) fixed by tomorrow morning.

-- 
Jeff Frost, Owner     <jeff@frostconsultingllc.com>
Frost Consulting, LLC     http://www.frostconsultingllc.com/
Phone: 650-780-7908    FAX: 650-649-1954


pgsql-sql by date:

Previous
From: "Daniel Caune"
Date:
Subject: Re: Power cut and performance problem
Next
From: "Marc G. Fournier"
Date:
Subject: Update counter when row SELECT'd ... ?