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!
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? |