| From: | David Rowley <david(dot)rowley(at)2ndquadrant(dot)com> |
|---|---|
| To: | Piotr Włodarczyk <piotrwlodarczyk89(at)gmail(dot)com> |
| Cc: | MichaelDBA <MichaelDBA(at)sqlexec(dot)com>, Michael Lewis <mlewis(at)entrata(dot)com>, Piotr Włodarczyk <piotr(dot)wlodarczyk(at)gnb(dot)pl>, "pgsql-performance(at)lists(dot)postgresql(dot)org" <pgsql-performance(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Planner performance in partitions |
| Date: | 2019-08-12 22:25:23 |
| Message-ID: | CAKJS1f9DEHYHu=hJPE_SYj9eheWK4F8iPNQGBApT4AHKgxVywQ@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
On Tue, 13 Aug 2019 at 08:03, Piotr Włodarczyk
<piotrwlodarczyk89(at)gmail(dot)com> wrote:
> PostgreSQL11.5:
>
> select on main partition (public.book): planner: 60ms, execution: 5ms
> select on partitioned table (public.book_1-1000): planner: 2.7 ms, execution: 2,4 ms
>
> PostgreSQL 12B3:
>
> select on main partition (public.book): planner: 2,5ms , execution: 1,2ms
> select on partitioned table (public.book_1-1000): planner: 2.5 ms, execution: 1,2 ms
>
> So looking at above results we have two options:
>
> Wait for 12.0 stable version
> Wait for patches to 11 – PostgreSQL Team: can You do this?
You'll need to either reduce the number of partitions down to
something realistic or wait for 12.0.
The work done to speed up the planner with partitioned tables for v12
won't be going into v11.
--
David Rowley http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Luís Roberto Weck | 2019-08-12 22:28:33 | Re: Last event per user |
| Previous Message | Michael Lewis | 2019-08-12 21:56:31 | Re: Last event per user |