Analyze the DB exactly how?
I did run a reindexdb after migration to no affect.
Yeah the PLANS are a big difference ....
Ben Duncan - Business Network Solutions, Inc. 336 Elton Road Jackson MS, 39212
"Never attribute to malice, that which can be adequately explained by stupidity"
- Hanlon's Razor
"Never attribute to malice, that which can be adequately explained by stupidity"
- Hanlon's Razor
-------- Original Message --------
Subject: Re: Issues on 9.5 to 9.6 Upgrade.
From: Don Seiler <don@xxxxxxxxx>
Date: Wed, June 13, 2018 11:24 am
To: bend@xxxxxxxxxxxx
Cc: Postgres General <pgsql-general@xxxxxxxxxxxxxx>
On Wed, Jun 13, 2018 at 11:16 AM, <bend@xxxxxxxxxxxx> wrote:Can anyoen explain WHY there is such a big difference? Is it the SQL statement or a bug in the pgdump ?
Did you analyze the database after upgrading? Or at least the tables in question? Those are very different plans.--Don Seiler
www.seiler.us
