Re: Gather performance analysis - Mailing list pgsql-hackers

From Dilip Kumar
Subject Re: Gather performance analysis
Date
Msg-id CAFiTN-v8-_W=tpwMv4u69wYnTNZ-kwUWHekT_h+UTS6UM=3fYQ@mail.gmail.com
Whole thread Raw
In response to Re: Gather performance analysis  (Tomas Vondra <tomas.vondra@enterprisedb.com>)
Responses Re: Gather performance analysis  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-hackers
On Tue, Oct 12, 2021 at 6:41 PM Tomas Vondra
<tomas.vondra@enterprisedb.com> wrote:
>
> On 9/28/21 14:00, Dilip Kumar wrote:
> >
> > I think that would be great, can we just test this specific target
> > where we are seeing a huge dip with the patch, e.g.
> > with 10000000 rows, 10 columns and 4 threads, and queue size 64k.  In
> > my performance machine, I tried to run this test multiple times but on
> > the head, it is taking ~2000 ms whereas with the patch it is ~1500 ms,
> > so I am not able to reproduce this.  So it would be good if you can
> > run only this specific test and repeat it a couple of times on your
> > performance machine.
> >
>
> I ran the benchmark again, with 10 runs instead of 5, the results and
> scripts are attached. It seems the worst case got much better and is now
> in line with the rest of the results, so it probably was a coincidence.

Thanks, yeah now it looks in line with other results.

-- 
Regards,
Dilip Kumar
EnterpriseDB: http://www.enterprisedb.com



pgsql-hackers by date:

Previous
From: Andrew Dunstan
Date:
Subject: Re: automatically generating node support functions
Next
From: Robert Haas
Date:
Subject: Re: pg14 psql broke \d datname.nspname.relname