Postgres Pro
Downloads
Home   >   mailing lists

Re: [PERFORM] performance drop after upgrade (9.6 > 10) - Mailing list pgsql-performance

From johannes graën
Subject Re: [PERFORM] performance drop after upgrade (9.6 > 10)
Date
Msg-id CA++JNScUoxYKBhURxbG_DzoUfgKJup4a4TXUTiG1FFjuq8X-VQ@mail.gmail.com
Whole thread Raw
In response to Re: [PERFORM] performance drop after upgrade (9.6 > 10)  (Pavel Stehule <pavel.stehule@gmail.com>)
Responses Re: [PERFORM] performance drop after upgrade (9.6 > 10)  (johannes graën <johannes@selfnet.de>)
List pgsql-performance
Tree view 
On Wed, Oct 11, 2017 at 1:11 PM, Pavel Stehule <pavel.stehule@gmail.com> wrote:
> have you fresh statistics? After upgrade is necessary to run ANALYZE command

Yes, that was missing indeed. I did ANALYZE but apparently on all
databases but this one. I could have guessed that
1,098,956,679,131,935,754,413,282,631,696,252,928 is not a reasonable
cost value.

Thanks, Pavel.

Best Johannes


-- 
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance

pgsql-performance by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: [PERFORM] performance drop after upgrade (9.6 > 10)
Next
From: Neto pr
Date:
Subject: [PERFORM] blocking index creation