From: | David Rowley <david(dot)rowley(at)2ndquadrant(dot)com> |
---|---|
To: | Amit Langote <Langote_Amit_f8(at)lab(dot)ntt(dot)co(dot)jp> |
Cc: | Robert Haas <robertmhaas(at)gmail(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org> |
Subject: | Re: Speeding up INSERTs and UPDATEs to partitioned tables |
Date: | 2018-11-08 22:26:05 |
Message-ID: | CAKJS1f-vYAHqqaU878Q4cdZYHwPcv1J_C-mG=Cs2UwhsD6cqwg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On 9 November 2018 at 00:28, David Rowley <david(dot)rowley(at)2ndquadrant(dot)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
--
David Rowley http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
Attachment | Content-Type | Size |
---|---|---|
v14-0002-Unsafe-locking-reduction-for-partitioned-INSERT-.patch | application/octet-stream | 2.4 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2018-11-08 22:37:06 | Re: Disallow setting client_min_messages > ERROR? |
Previous Message | David Rowley | 2018-11-08 20:59:36 | Re: ATTACH/DETACH PARTITION CONCURRENTLY |