| From: | Dilip Kumar <dilipbalaut(at)gmail(dot)com> |
|---|---|
| To: | Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com> |
| Cc: | Robert Haas <robertmhaas(at)gmail(dot)com>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Gather performance analysis |
| Date: | 2021-09-26 05:51:52 |
| Message-ID: | CAFiTN-syVqCafV=9NBHT+E1=xa=SxhBW4KCy9B4JtoyrS87RKQ@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Sat, Sep 25, 2021 at 2:18 AM Tomas Vondra
<tomas(dot)vondra(at)enterprisedb(dot)com> wrote:
>
> On 9/24/21 7:08 PM, Robert Haas wrote:
> > On Fri, Sep 24, 2021 at 3:50 AM Dilip Kumar <dilipbalaut(at)gmail(dot)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
| Attachment | Content-Type | Size |
|---|---|---|
| results.ods | application/vnd.oasis.opendocument.spreadsheet | 12.6 KB |
| cpuinfo | application/octet-stream | 738 bytes |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Fabien COELHO | 2021-09-26 05:55:22 | Re: rand48 replacement |
| Previous Message | wenjing | 2021-09-26 04:04:53 | Re: [Proposal] Global temporary tables |