| From: | Jesper Pedersen <jesper(dot)pedersen(at)redhat(dot)com> |
|---|---|
| To: | Alvaro Herrera <alvherre(at)2ndquadrant(dot)com> |
| Cc: | Amit Langote <Langote_Amit_f8(at)lab(dot)ntt(dot)co(dot)jp>, Pg Hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: partitioned tables referenced by FKs |
| Date: | 2019-03-22 13:01:34 |
| Message-ID: | d1f5e3ba-5c92-9173-2e6b-47884f7a82f0@redhat.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael Banck | 2019-03-22 13:23:17 | Re: Progress reporting for pg_verify_checksums |
| Previous Message | Andrey Borodin | 2019-03-22 12:48:15 | Re: GiST VACUUM |