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


-------- Original Message --------
Subject: Re: Issues on 9.5 to 9.6 Upgrade.
From: Don Seiler <don@seiler.us>
Date: Wed, June 13, 2018 11:24 am
To: bend@linux4ms.net
Cc: Postgres General <pgsql-general@postgresql.org>

On Wed, Jun 13, 2018 at 11:16 AM, <bend@linux4ms.net> 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