Le 03/09/2019 à 15:43, Tom Lane a écrit :
"Arnaud L." <arnaud.listes@xxxxxxxxx> 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
