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...
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
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
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.
Servers: Redhack 6.9 64 bit.Postgres OLD Server version 9.5.6Postgres New Server 9.6.6Issues BIG difference in speed on the following SQL statement from 9.5 to 9.6 ...EXPLAIN ANALYZEselect de_caseid, de_seqno, de_document_num, doc_link.dm_id as dm_id, doc_link.dm_seq as dm_seq, doc_link.dm_dls_id
