R: Postgres 9.6.1 big slowdown by upgrading 8.4.22

From: Job <Job(at)colliniconsulting(dot)it>
To: 'Tomas Vondra' <tomas(dot)vondra(at)2ndquadrant(dot)com>, Alban Hertroys <haramrae(at)gmail(dot)com>, Job <Job(at)colliniconsulting(dot)it>
Cc: Rob Sargent <robjsargent(at)gmail(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: R: Postgres 9.6.1 big slowdown by upgrading 8.4.22
Date: 2017-01-08 10:23:37
Message-ID: 88EF58F000EC4B4684700C2AA3A73D7A08054EACC250@W2008DC01.ColliniConsulting.lan
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi guys,

>>FWIW you still haven't explained how the upgrade was performed. That might be a very important piece of information, because the 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Thomas Kellerer 2017-01-08 11:21:08 Re: R: Postgres 9.6.1 big slowdown by upgrading 8.4.22
Previous Message Adrian Klaver 2017-01-08 04:18:25 Re: Catalog table which stores database level information