Re: Speeding up INSERTs and UPDATEs to partitioned tables

From: Krzysztof Nienartowicz <krzysztof(dot)nienartowicz(at)gmail(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Speeding up INSERTs and UPDATEs to partitioned tables
Date: 2018-10-15 10:04:13
Message-ID: 1539597853300-0.post@n3.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Amit Langote 2018-10-15 10:34:56 Re: Speeding up INSERTs and UPDATEs to partitioned tables
Previous Message Amit Langote 2018-10-15 09:24:15 Re: speeding up planning with partitions