Re: Issues on 9.5 to 9.6 Upgrade.
От | Adrian Klaver |
---|---|
Тема | Re: Issues on 9.5 to 9.6 Upgrade. |
Дата | |
Msg-id | f6fbd589-5c41-5827-6396-e9591229ef25@aklaver.com обсуждение исходный текст |
Список | pgsql-general |
On 06/13/2018 09:44 AM, bend@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 <don@seiler.us <mailto:don@seiler.us>> > Date: Wed, June 13, 2018 11:24 am > To: bend@linux4ms.net <mailto:bend@linux4ms.net> > Cc: Postgres General <pgsql-general@postgresql.org > <mailto:pgsql-general@postgresql.org>> > > On Wed, Jun 13, 2018 at 11:16 AM, <bend@linux4ms.net > <mailto: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 <http://www.seiler.us> > -- Adrian Klaver adrian.klaver@aklaver.com
В списке pgsql-general по дате отправления: