Re: partitioned tables referenced by FKs

Hi Jesper,

On 2019/03/22 22:01, Jesper Pedersen wrote:
> 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%

Wouldn't you get the same numbers on HEAD too? IOW, I'm not sure how the
patch here, which seems mostly about getting DDL in order to support
foreign keys on partitioned tables, would have affected the result of this
benchmark. Can you clarify your intention of running this benchmark
against these patches?

Thanks,
Amit