Slow PG after upgrade to 8.2.9!!

Поиск
Список
Период
Сортировка
От Phoenix Kiula
Тема Slow PG after upgrade to 8.2.9!!
Дата
Msg-id e373d31e0808280023w66ad9bd9m72504d68e24d7d2b@mail.gmail.com
обсуждение исходный текст
Ответы Re: Slow PG after upgrade to 8.2.9!!  ("Phoenix Kiula" <phoenix.kiula@gmail.com>)
Re: Slow PG after upgrade to 8.2.9!!  (Andreas Kretschmer <akretschmer@spamfence.net>)
Re: Slow PG after upgrade to 8.2.9!!  (Devrim GÜNDÜZ <devrim@gunduz.org>)
Список 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!

В списке pgsql-general по дате отправления:

Предыдущее
От: Ow Mun Heng
Дата:
Сообщение: Partitioned Tables - How/Can does slony handle it?
Следующее
От: Magnus Hagander
Дата:
Сообщение: Re: Partitioned Tables - How/Can does slony handle it?