RE: Issues on 9.5 to 9.6 Upgrade.

2018-06-13 Thread bend
tupidity"- Hanlon's Razor Original Message ---- Subject: Re: Issues on 9.5 to 9.6 Upgrade. From: Adrian Klaver <adrian.kla...@aklaver.com> Date: Wed, June 13, 2018 11:45 am To: b...@linux4ms.net, Postgres General <pgsql-gene...@postgresql.org> On 06/13/2018 09:44 AM, b...

Re: Issues on 9.5 to 9.6 Upgrade.

2018-06-13 Thread Adrian Klaver
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 mailto:d...@seiler.us>> Date: Wed, June 13, 20

RE: Issues on 9.5 to 9.6 Upgrade.

2018-06-13 Thread bend
on's Razor Original Message -------- Subject: Re: Issues on 9.5 to 9.6 Upgrade. From: Don Seiler <d...@seiler.us> Date: Wed, June 13, 2018 11:24 am To: b...@linux4ms.net Cc: Postgres General <pgsql-gene...@postgresql.org> On Wed, Jun 13, 2018 at 11:16 AM, <b...@linux4ms

Re: Issues on 9.5 to 9.6 Upgrade.

2018-06-13 Thread Don Seiler
On Wed, Jun 13, 2018 at 11:16 AM, 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.