Upgrade from 9.1.6 to 9,1.7 seems to have caused a major slowdown

Поиск
Список
Период
Сортировка
От Greg Williamson
Тема Upgrade from 9.1.6 to 9,1.7 seems to have caused a major slowdown
Дата
Msg-id 1356001615.20304.YahooMailNeo@web125905.mail.ne1.yahoo.com
обсуждение исходный текст
Ответы Re: Upgrade from 9.1.6 to 9,1.7 seems to have caused a major slowdown
Список pgsql-admin
Дерево обсуждения 
Dear peoples,


Today we upgraded a small (7.5 megabytes) but hyperactive database from postgresql 9.1.6 to 9.1.7 (we use INDEX
CONCURRENTLYa lot) and after restarting it looks as if we have a slower system -- fewer queries, but more long ones,
fewercheckpoints. I am still manually comparing config  settings to see if anything changed (shouldn't have but ...). 

Has anyone else seen anything like this ?

I  suspect some site error had led to us scoring an own-goal but I thought I'd ask and see if anyone else has seen
this.


Thanks,

Greg Williamson

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

Предыдущее
От: Baptiste LHOSTE
Дата:
Сообщение: Re: [Autovacuum] Issue to understand some logs
Следующее
От: Baptiste LHOSTE
Дата:
Сообщение: Autovacuum issues with truncate and create index ...