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 <[EMAIL PROTECTED]>
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 650-780-7908 FAX: 650-649-1954
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
