Slow PG after upgrade to 8.2.9!!

From: "Phoenix Kiula" <phoenix(dot)kiula(at)gmail(dot)com>
To: "PG-General Mailing List" <pgsql-general(at)postgresql(dot)org>
Subject: Slow PG after upgrade to 8.2.9!!
Date: 2008-08-28 07:23:39
Message-ID: e373d31e0808280023w66ad9bd9m72504d68e24d7d2b@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I hope someone can urgently help. I was running 8.2.3 with a lot of
pleasure and no-nonsense. Very fast and delightful database that had
me singing paeans.

But I upgraded to 8.2.9 this morning and have had a major slowdown of
the DB processes. How do I begin to test what is going wrong?

I checked the log files and there are "LOG: duration: 84533.845 ms
statement: " type errors messages for the simplest of queries that
call the indexes into question.

Nothing has ben changed on the db or in the conf files other than just
the RPM upgrade!

The SELECTs are taking about 85 seconds and the main INSERT to a table
(no binary blob or anything, just usual data!) is taking about 145
seconds sometimes.

How can I begin to diagnose what is wrong? Has there been a major
change to some CONF variables between versions 8.2.3 and 8.2.9 that I
should look at?

Thanks for any pointers or direction!

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Magnus Hagander 2008-08-28 07:33:39 Re: Partitioned Tables - How/Can does slony handle it?
Previous Message Ow Mun Heng 2008-08-28 07:20:19 Partitioned Tables - How/Can does slony handle it?