On 9 November 2018 at 00:28, David Rowley <david.row...@2ndquadrant.com> wrote: > I've attached v15 and a delta from v14 to ease re-review.
I just revived the 0002 patch, which is still just for testing at this stage. There was mention over on [1] about removing the find_all_inheritors() call. Also some benchmarks from v14 with 0001+0002. Setup: DROP TABLE hashp; CREATE TABLE hashp (a INT) PARTITION BY HASH (a); SELECT 'CREATE TABLE hashp'||x::Text || ' PARTITION OF hashp FOR VALUES WITH (modulus 10000, remainder ' || x::text || ');' from generate_Series(0,9999) x; \gexec (0 partitions is a non-partitioned table) fsync=off Partitions Patched Unpatched 0 23672 23785 10 22794 18385 100 22392 8541 1000 22419 1159 10000 22195 101 [1] https://www.postgresql.org/message-id/ca+tgmozgjsy-nrfnzurhzqjthddh5fzjkvbvhs0byn6_46p...@mail.gmail.com -- David Rowley http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services
v14-0002-Unsafe-locking-reduction-for-partitioned-INSERT-.patch
Description: Binary data