Hello!
I have got huge planning time for a query in quite small database in PortgreSQL 17 Planning Time: 452.796 ms Execution Time: 0.350 ms
Tried several version from 17.3 to 17.7 (cpu 2.2GHz) - it almost does not matter. If I run query many times in row planning time may reduce down to 430ms but never less.
Tried in PortgreSQL 11 (in a little bit different hardware with cpu 2.60GHz) - planning time almost ten times less.
Changing parameters : from_collapse_limit, join_collapse_limit, geqo, jit, work_mem and many others does not help at all.
I attach
1. additional setting in the postgresql.status.conf.
2. querry itself in query.sql.
3. zql plan in query.sqlplan
4. additioanal information about os, tables etc.
would you please help me
-Alexander Kulikov
