Postgres Pro
Downloads
Home   >   mailing lists

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

From Krzysztof Nienartowicz
Subject Re: Speeding up INSERTs and UPDATEs to partitioned tables
Date
Msg-id 1539597853300-0.post@n3.nabble.com
Whole thread Raw
In response to Re: Speeding up INSERTs and UPDATEs to partitioned tables  (David Rowley <david.rowley@2ndquadrant.com>)
Responses Re: Speeding up INSERTs and UPDATEs to partitioned tables  (Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>)
Re: Speeding up INSERTs and UPDATEs to partitioned tables  (David Rowley <david.rowley@2ndquadrant.com>)
List pgsql-hackers
Tree view 
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?

Thanks
Krzysztof



--
Sent from: http://www.postgresql-archive.org/PostgreSQL-hackers-f1928748.html

pgsql-hackers by date:

Previous
From: Amit Langote
Date:
Subject: Re: speeding up planning with partitions
Next
From: Amit Langote
Date:
Subject: Re: Speeding up INSERTs and UPDATEs to partitioned tables