Re: Speeding up INSERTs and UPDATEs to partitioned tables

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

Hi,

Thanks a lot for benchmarking this.

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.

--
David Rowley http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services