Re: Speeding up INSERTs and UPDATEs to partitioned tables - Mailing list pgsql-hackers

From Amit Langote
Subject Re: Speeding up INSERTs and UPDATEs to partitioned tables
Date
Msg-id a9c2dd8f-f406-e59e-65f5-a837cf033e52@lab.ntt.co.jp
Whole thread Raw
In response to Re: Speeding up INSERTs and UPDATEs to partitioned tables  (Krzysztof Nienartowicz <krzysztof.nienartowicz@gmail.com>)
List 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



pgsql-hackers by date:

Previous
From: Krzysztof Nienartowicz
Date:
Subject: Re: Speeding up INSERTs and UPDATEs to partitioned tables
Next
From: John Naylor
Date:
Subject: Re: WIP: Avoid creation of the free space map for small tables