Postgres Pro
Downloads
Home   >   mailing lists

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

From legrand legrand
Subject Re: BUG #16109: Postgres planning time is high across version -10.6 vs 10.10
Date
Msg-id 1573594875394-0.post@n3.nabble.com
Whole thread Raw
In response to Re: BUG #16109: Postgres planning time is high across version - 10.6vs 10.10  (Mukesh Chhatani <chhatani.mukesh@gmail.com>)
List pgsql-bugs
Tree view 
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

pgsql-bugs by date:

Previous
From: Mukesh Chhatani
Date:
Subject: Re: BUG #16109: Postgres planning time is high across version - 10.6vs 10.10
Next
From: Tom Lane
Date:
Subject: Re: [BUG FIX] Uninitialized var fargtypes used.