Postgres Pro
Downloads
Home   >   mailing lists

R: [GENERAL] Postgres 9.6.1 big slowdown by upgrading 8.4.22 - Mailing list pgsql-general

From Job
Subject R: [GENERAL] Postgres 9.6.1 big slowdown by upgrading 8.4.22
Date
Msg-id 88EF58F000EC4B4684700C2AA3A73D7A08054EACC250@W2008DC01.ColliniConsulting.lan
Whole thread Raw
In response to Re: [GENERAL] Postgres 9.6.1 big slowdown by upgrading 8.4.22  (Tomas Vondra <tomas.vondra@2ndquadrant.com>)
Responses 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>)
List pgsql-general
Tree view 
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 by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: [GENERAL] Catalog table which stores database level information
Next
From: Thomas Kellerer
Date:
Subject: Re: [GENERAL] R: Postgres 9.6.1 big slowdown by upgrading 8.4.22