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@frostconsultingllc.com>
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 650-780-7908 FAX: 650-649-1954