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