On Sat, Sep 25, 2021 at 2:18 AM Tomas Vondra
<tomas.vondra@enterprisedb.com> wrote:
>
> On 9/24/21 7:08 PM, Robert Haas wrote:
> > On Fri, Sep 24, 2021 at 3:50 AM Dilip Kumar <dilipbalaut@gmail.com> wrote:
> >> Tomas, can you share your test script, I would like to repeat the same
> >> test in my environment and with different batching sizes.
For now I have tested for 1M and 10M rows, shared buffers=16GM, for
now tested with default batching 1/4th of the queue size and I can see
the performance gain is huge. Time taken with the patch is in the
range of 37-90% compared to the master. Please refer to the attached
file for more detailed results. I could not see any regression that
Tomas saw, still I am planning to repeat it with different batch
sizes.
--
Regards,
Dilip Kumar
EnterpriseDB: http://www.enterprisedb.com