Re: BUG #16109: Postgres planning time is high across version - 10.6 vs 10.10

legrand legrand <legrand_legrand@hotmail.com>

From: legrand legrand <legrand_legrand@hotmail.com>

To: pgsql-bugs@postgresql.org

Date: 2019-11-12T21:41:15Z

Lists: pgsql-bugs, pgsql-hackers

Hello,

there was a very similar post a few days ago:
https://www.postgresql-archive.org/Slow-planning-fast-execution-for-particular-3-table-query-tt6109879.html#none

the root cause was a modification of default_statistics_target

Maybe you are in the same situation ?
or maybe tables have different SET STATISTICS values set ?

Regards
PAscal



--
Sent from: https://www.postgresql-archive.org/PostgreSQL-bugs-f2117394.html

Commits

Include information on buffer usage during planning phase, in EXPLAIN output, take two.
- ce77abe63cfc 13.0 landed
Include information on buffer usage during planning phase, in EXPLAIN output.
- ed7a5095716e 13.0 landed
Expose BufferUsageAccumDiff().
- 4a539a25ebfc 13.0 cited