Re: Power cut and performance problem

From: Jeff Frost <jeff(at)frostconsultingllc(dot)com>
To: Daniel Caune <daniel(dot)caune(at)ubisoft(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Power cut and performance problem
Date: 2006-03-20 23:27:24
Message-ID: Pine.LNX.4.64.0603201523430.14639@discord.dyndns.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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?

On Mon, 20 Mar 2006, Daniel Caune wrote:

> Hi,
>
> We had a power cut lastly and it seems that our PostgreSQL database
> suffers from performance since. For example, a simple query such as
> "SELECT MIN(a-primary-key-column) FROM a-table" takes quite a very long
> time; actually I gave up before getting the result.

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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Daniel Caune 2006-03-20 23:50:30 Re: Power cut and performance problem
Previous Message Daniel Caune 2006-03-20 23:19:43 Power cut and performance problem