| From: | Amit Langote <Langote_Amit_f8(at)lab(dot)ntt(dot)co(dot)jp> |
|---|---|
| To: | Krzysztof Nienartowicz <krzysztof(dot)nienartowicz(at)gmail(dot)com>, pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: Speeding up INSERTs and UPDATEs to partitioned tables |
| Date: | 2018-10-15 10:34:56 |
| Message-ID: | a9c2dd8f-f406-e59e-65f5-a837cf033e52@lab.ntt.co.jp |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Hi,
On 2018/10/15 19:04, Krzysztof Nienartowicz wrote:
>
> We see quite prohibitive 5-6x slowdown with native partitioning on in
> comparison to trigger based in PG9.5.
> This is clearly visible with highly parallel inserts (Can share
> flamediagrams comparing the two).
>
> This basically excludes native partitioning from being used by us. Do you
> think your changes could be backported to PG10? - we checked and this would
> need quite a number of changes but given the weight of this change maybe it
> could be considered?
It's unfortunate that PG 10's partitioning cannot be used for your use
case, but I don't think such a major refactoring will be back-ported to 10
or 11. :-(
Thanks,
Amit
| From | Date | Subject | |
|---|---|---|---|
| Next Message | John Naylor | 2018-10-15 10:39:34 | Re: WIP: Avoid creation of the free space map for small tables |
| Previous Message | Krzysztof Nienartowicz | 2018-10-15 10:04:13 | Re: Speeding up INSERTs and UPDATEs to partitioned tables |