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

From: legrand legrand <legrand_legrand(at)hotmail(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #16109: Postgres planning time is high across version - 10.6 vs 10.10
Date: 2019-11-12 21:41:15
Message-ID: 1573594875394-0.post@n3.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2019-11-12 21:59:32 Re: [BUG FIX] Uninitialized var fargtypes used.
Previous Message Mukesh Chhatani 2019-11-12 21:01:28 Re: BUG #16109: Postgres planning time is high across version - 10.6 vs 10.10

Browse pgsql-hackers by date

  From Date Subject
Next Message Maciek Sakrejda 2019-11-12 21:42:10 Re: JIT performance bug/regression & JIT EXPLAIN
Previous Message Andres Freund 2019-11-12 21:21:08 Re: Missing dependency tracking for TableFunc nodes