| From: | Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com> |
|---|---|
| To: | Dilip Kumar <dilipbalaut(at)gmail(dot)com> |
| Cc: | Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>, Robert Haas <robertmhaas(at)gmail(dot)com>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Gather performance analysis |
| Date: | 2021-10-12 13:10:51 |
| Message-ID: | 45615ff2-3cf0-9ca3-0d60-07132a09eb22@enterprisedb.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
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.
regards
--
Tomas Vondra
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
| Attachment | Content-Type | Size |
|---|---|---|
| run.sh | application/x-shellscript | 1.5 KB |
| results.ods | application/vnd.oasis.opendocument.spreadsheet | 165.9 KB |
| postgresql.conf | text/plain | 28.1 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2021-10-12 13:14:12 | Re: storing an explicit nonce |
| Previous Message | Peter Eisentraut | 2021-10-12 13:04:04 | Re: automatically generating node support functions |