R: [GENERAL] Postgres 9.6.1 big slowdown by upgrading 8.4.22

Поиск
Список
Период
Сортировка
От Job
Тема R: [GENERAL] Postgres 9.6.1 big slowdown by upgrading 8.4.22
Дата
Msg-id 88EF58F000EC4B4684700C2AA3A73D7A08054EACC250@W2008DC01.ColliniConsulting.lan
обсуждение исходный текст
Ответ на Re: [GENERAL] Postgres 9.6.1 big slowdown by upgrading 8.4.22  (Tomas Vondra <tomas.vondra@2ndquadrant.com>)
Ответы Re: [GENERAL] R: Postgres 9.6.1 big slowdown by upgrading 8.4.22  (Thomas Kellerer <spam_eater@gmx.net>)
R: [GENERAL] Postgres 9.6.1 big slowdown by upgrading 8.4.22  (Job <Job@colliniconsulting.it>)
Список pgsql-general
Дерево обсуждения 
Hi guys,

>>FWIW you still haven't explained how the upgrade was performed. That might be a very important piece of information,
becausethe 9.4 cluster might have hint bits set and/or the data may be mostly frozen, but the 
>>9.6 cluster may not have that yet, resulting in higher CPU usage.

We upgraded the database with a pg_dumpall from 8.4.22 and then a psql < BACKUP.SAV command!

Thank you again!
Francesco

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

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: [GENERAL] Catalog table which stores database level information
Следующее
От: Thomas Kellerer
Дата:
Сообщение: Re: [GENERAL] R: Postgres 9.6.1 big slowdown by upgrading 8.4.22