Re: [PERFORM] performance drop after upgrade (9.6 > 10)

Поиск
Список
Период
Сортировка
От johannes graën
Тема Re: [PERFORM] performance drop after upgrade (9.6 > 10)
Дата
Msg-id CA++JNScUoxYKBhURxbG_DzoUfgKJup4a4TXUTiG1FFjuq8X-VQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [PERFORM] performance drop after upgrade (9.6 > 10)  (Pavel Stehule <pavel.stehule@gmail.com>)
Ответы Re: [PERFORM] performance drop after upgrade (9.6 > 10)
Список pgsql-performance
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 по дате отправления:

Предыдущее
От: Pavel Stehule
Дата:
Сообщение: Re: [PERFORM] performance drop after upgrade (9.6 > 10)
Следующее
От: Neto pr
Дата:
Сообщение: [PERFORM] blocking index creation