| From: | "Anton A(dot) Melnikov" <a(dot)melnikov(at)postgrespro(dot)ru> |
|---|---|
| To: | "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Some performance degradation in REL_16 vs REL_15 |
| Date: | 2023-10-12 08:00:22 |
| Message-ID: | 79e2f903-8bb0-4fc9-840c-f30d878d2327@postgrespro.ru |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Greetengs!
Found that simple test pgbench -c20 -T20 -j8 gives approximately
for REL_15_STABLE at 5143f76: 336+-1 TPS
and
for REL_16_STABLE at 4ac7635f: 324+-1 TPS
The performance drop is approximately 3,5% while the corrected standard deviation is only 0.3%.
See the raw_data.txt attached.
How do you think, is there any cause for concern here?
And is it worth spending time bisecting for the commit where this degradation may have occurred?
Would be glad for any comments and concerns.
With the best regards,
--
Anton A. Melnikov
Postgres Professional: http://www.postgrespro.com
The Russian Postgres Company
| Attachment | Content-Type | Size |
|---|---|---|
| raw_data.txt | text/plain | 171 bytes |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David Rowley | 2023-10-12 08:18:53 | Re: Doc: Minor update for enable_partitionwise_aggregate |
| Previous Message | Andy Fan | 2023-10-12 07:52:07 | Re: A new strategy for pull-up correlated ANY_SUBLINK |