Re: Speeding up INSERTs and UPDATEs to partitioned tables

On 2018-Jul-11, David Rowley wrote:

> On 6 July 2018 at 21:25, Kato, Sho <kato-sho(at)jp(dot)fujitsu(dot)com> wrote:
> > 2. 11beta2 + patch1 + patch2
> >
> > patch1: Allow direct lookups of AppendRelInfo by child relid
> > commit 7d872c91a3f9d49b56117557cdbb0c3d4c620687
> > patch2: 0001-Speed-up-INSERT-and-UPDATE-on-partitioned-tables.patch
> >
> > part_num | tps_ex | latency_avg | update_latency | select_latency | insert_latency
> > ----------+-------------+-------------+----------------+----------------+----------------
> > 100 | 1224.430344 | 0.817 | 0.551 | 0.085 | 0.048
> > 200 | 689.567511 | 1.45 | 1.12 | 0.119 | 0.05
> > 400 | 347.876616 | 2.875 | 2.419 | 0.185 | 0.052
> > 800 | 140.489269 | 7.118 | 6.393 | 0.329 | 0.059
> > 1600 | 29.681672 | 33.691 | 31.272 | 1.517 | 0.147
> > 3200 | 7.021957 | 142.412 | 136.4 | 4.033 | 0.214
> > 6400 | 1.462949 | 683.557 | 669.187 | 7.677 | 0.264

> Just a note to say that the "Allow direct lookups of AppendRelInfo by
> child relid" patch is already in master. It's much more relevant to be
> testing with master than pg11. This patch is not intended for pg11.

That commit is also in pg11, though -- just not in beta2. So we still
don't know how much of an improvement patch2 is by itself :-)

--
Álvaro Herrera https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services