Re: partitioned tables referenced by FKs - Mailing list pgsql-hackers

Hi Alvaro,

On 3/21/19 6:18 PM, Alvaro Herrera wrote:
> On 2019-Mar-21, Jesper Pedersen wrote:
>> pgbench -M prepared -f select.sql ....
>>
>> I'm seeing 82.64% spent in GetCachedPlan(). plan_cache_mode is auto.
> 
> Hmm, I can't reproduce this at all ...  I don't even see GetCachedPlan
> in the profile.  Do you maybe have some additional patch in your tree?
> 

No, with 7df159a62 and v7 compiled with "-O0 -fno-omit-frame-pointer" I 
still see it.

plan_cache_mode = auto
   2394 TPS w/ GetCachePlan() @ 81.79%

plan_cache_mode = force_generic_plan
  10984 TPS w/ GetCachePlan() @ 23.52%

perf sent off-list.

Best regards,
  Jesper