Re: Slow statement using parallelism after 9.6>11 upgrade

Поиск
Список
Период
Сортировка
От Arnaud L.
Тема Re: Slow statement using parallelism after 9.6>11 upgrade
Дата
Msg-id 938dfead-0605-8f91-8f21-8871f44bd6ff@codata.eu
обсуждение исходный текст
Ответ на Re: Slow statement using parallelism after 9.6>11 upgrade  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Slow statement using parallelism after 9.6>11 upgrade
Список pgsql-general
Le 03/09/2019 à 15:43, Tom Lane a écrit :
> "Arnaud L." <arnaud.listes@codata.eu> writes:
>> We have upgraded our database from 9.6 to 11 (and updated PostGIS from 
>> 2.3 to 2.5 as well).
>> ...
> 
> Have you re-ANALYZEd the database?  The problem with this query
> seems to be the spectacularly awful rowcount estimate here:

You mean after the upgrade process ? Yes I have.
I've juste re-run "ANALYZE table" to rule this out, estimates are the same.

Maybe some statistic target problem ? Estimated number of rows is 
284.196.352
Also, this is a GIN index on a bigint[] column.

I've setup parallel_tuple_cost to 1.0 parallel_setup_cost to 5000.0 for 
the time being which solves this specific problem. These value don't 
look very sensible though, they are very high compared to the default ones.

Cheers
--
Arnaud



В списке pgsql-general по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Slow statement using parallelism after 9.6>11 upgrade
Следующее
От: Paul Ramsey
Дата:
Сообщение: Re: Slow statement using parallelism after 9.6>11 upgrade