Re: Gather performance analysis

Поиск
Список
Период
Сортировка
От Dilip Kumar
Тема Re: Gather performance analysis
Дата
Msg-id CAFiTN-v8-_W=tpwMv4u69wYnTNZ-kwUWHekT_h+UTS6UM=3fYQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Gather performance analysis  (Tomas Vondra <tomas.vondra@enterprisedb.com>)
Ответы Re: Gather performance analysis  (Robert Haas <robertmhaas@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Andrew Dunstan
Дата:
Сообщение: Re: automatically generating node support functions
Следующее
От: Robert Haas
Дата:
Сообщение: Re: pg14 psql broke \d datname.nspname.relname