| From: | Jesper Pedersen <jesper(dot)pedersen(at)redhat(dot)com> |
|---|---|
| To: | Amit Langote <Langote_Amit_f8(at)lab(dot)ntt(dot)co(dot)jp> |
| Cc: | Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>, "Imai, Yoshikazu" <imai(dot)yoshikazu(at)jp(dot)fujitsu(dot)com>, Pg Hackers <pgsql-hackers(at)postgresql(dot)org>, David Rowley <david(dot)rowley(at)2ndquadrant(dot)com> |
| Subject: | Re: speeding up planning with partitions |
| Date: | 2018-11-09 17:43:24 |
| Message-ID: | 806bfbbb-c41e-cc22-7761-841255e8a932@redhat.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Hi Amit,
On 11/9/18 3:55 AM, Amit Langote wrote:
> And here are patches structured that way. I've addressed some of the
> comments posted by Imai-san upthread. Also, since David's patch to
> postpone PlannerInfo.total_pages calculation went into the tree earlier
> this week, it's no longer included in this set.
>
Thanks for doing the split this way. The patch passes check-world.
I ran a SELECT test using hash partitions, and got
Master v5
64: 6k 59k
1024: 283 59k
The non-partitioned case gives 77k. The difference in TPS between the
partition case vs. the non-partitioned case comes down to
set_plain_rel_size() vs. set_append_rel_size() under
set_base_rel_sizes(); flamegraphs for this sent off-list.
Best regards,
Jesper
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2018-11-09 17:45:40 | Re: ALTER DEFAULT PRIVILEGES is buggy, and so is its testing |
| Previous Message | Konstantin Knizhnik | 2018-11-09 17:23:42 | Re: [HACKERS] Surjective functional indexes |