On Sat, Sep 25, 2021 at 2:18 AM Tomas Vondra <tomas.von...@enterprisedb.com> wrote: > > On 9/24/21 7:08 PM, Robert Haas wrote: > > On Fri, Sep 24, 2021 at 3:50 AM Dilip Kumar <dilipbal...@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
results.ods
Description: application/vnd.oasis.opendocument.spreadsheet
cpuinfo
Description: Binary data
