From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
---|---|
To: | bend(at)linux4ms(dot)net, Postgres General <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Issues on 9.5 to 9.6 Upgrade. |
Date: | 2018-06-13 16:45:55 |
Message-ID: | f6fbd589-5c41-5827-6396-e9591229ef25@aklaver.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 06/13/2018 09:44 AM, bend(at)linux4ms(dot)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 <don(at)seiler(dot)us <mailto:don(at)seiler(dot)us>>
> Date: Wed, June 13, 2018 11:24 am
> To: bend(at)linux4ms(dot)net <mailto:bend(at)linux4ms(dot)net>
> Cc: Postgres General <pgsql-general(at)postgresql(dot)org
> <mailto:pgsql-general(at)postgresql(dot)org>>
>
> On Wed, Jun 13, 2018 at 11:16 AM, <bend(at)linux4ms(dot)net
> <mailto:bend(at)linux4ms(dot)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(dot)klaver(at)aklaver(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | bend | 2018-06-13 16:57:22 | RE: Issues on 9.5 to 9.6 Upgrade. |
Previous Message | bend | 2018-06-13 16:44:12 | RE: Issues on 9.5 to 9.6 Upgrade. |