8.1beta3 performance

Поиск
Список
Период
Сортировка
От PostgreSQL
Тема 8.1beta3 performance
Дата
Msg-id dk68ku$2lqa$1@news.hub.org
обсуждение исходный текст
Ответы Re: 8.1beta3 performance  ("Steinar H. Gunderson" <sgunderson@bigfoot.com>)
Re: 8.1beta3 performance  (Neil Conway <neilc@samurai.com>)
Re: 8.1beta3 performance  (Jon Brisbin <jon.brisbin@npcinternational.com>)
Список pgsql-performance
We're running 8.1beta3 on one server and are having ridiculous performance
issues.  This is a 2 cpu Opteron box and both processors are staying at 98
or 99% utilization processing not-that-complex queries.  Prior to the
upgrade, our I/O wait time was about 60% and cpu utilization rarely got very
high, now I/O wait time is at or near zero.

I'm planning to go back to 8.0 tonight or tomorrow night but thought I'd
check the pqsql-performance prophets before I gave it up.



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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: 8.x index insert performance
Следующее
От: mark@mark.mielke.cc
Дата:
Сообщение: Re: 8.x index insert performance