On 06/13/2018 09:44 AM, b...@linux4ms.net wrote:
Analyze the DB exactly how?
https://www.postgresql.org/docs/10/static/sql-analyze.html
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 <d...@seiler.us <mailto:d...@seiler.us>>
Date: Wed, June 13, 2018 11:24 am
To: b...@linux4ms.net <mailto:b...@linux4ms.net>
Cc: Postgres General <pgsql-gene...@postgresql.org
<mailto:pgsql-gene...@postgresql.org>>
On Wed, Jun 13, 2018 at 11:16 AM, <b...@linux4ms.net
<mailto:b...@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 <http://www.seiler.us>
--
Adrian Klaver
adrian.kla...@aklaver.com
