Re: v17 vs v16 performance comparison

2024-09-02 Thread Thomas Munro
On Tue, Sep 3, 2024 at 5:00 PM Alexander Lakhin wrote: > From a bird's eye view, new v17-vs-v16 comparison has only 87 "worse", > while the previous one had 115 (it requires deeper analysis, of course, but > still...). Any chance you could share that whole pgdata dir with me, assuming it compres

Re: v17 vs v16 performance comparison

2024-09-02 Thread Alexander Lakhin
Hello Thomas, 02.08.2024 12:00, Alexander Lakhin wrote: I had payed attention to: Best pg-src-17--.* worse than pg-src-16--.* by 57.9 percents (225.11 > 142.52): pg_tpcds.query15 Average pg-src-17--.* worse than pg-src-16--.* by 55.5 percents (230.57 > 148.29): pg_tpcds.query15 in May, p

Re: v17 vs v16 performance comparison

2024-08-02 Thread Alexander Lakhin
01.08.2024 06:41, Tom Lane wrote: But beside that, I've found a separate regression. Bisecting for this degradation: Best pg-src-17--.* worse than pg-src-16--.* by 105.0 percents (356.63 > 173.96): s64da_tpcds.query95 Average pg-src-17--.* worse than pg-src-16--.* by 105.2 percents (357.79 >

Re: v17 vs v16 performance comparison

2024-08-01 Thread Alexander Lakhin
Hello Thomas. 01.08.2024 08:57, Thomas Munro wrote: On Thu, Aug 1, 2024 at 3:00 PM Alexander Lakhin wrote: So it looks like q15 from TPC-DS is not the only query suffering from that change. I'm going to try to set up a local repro to study these new cases. If you have a write-up somewhere of

Re: v17 vs v16 performance comparison

2024-07-31 Thread Thomas Munro
On Thu, Aug 1, 2024 at 3:00 PM Alexander Lakhin wrote: > So it looks like q15 from TPC-DS is not the only query suffering from that > change. I'm going to try to set up a local repro to study these new cases. If you have a write-up somewhere of how exactly you run that, that'd be useful.

Re: v17 vs v16 performance comparison

2024-07-31 Thread Tom Lane
Alexander Lakhin writes: > I've repeated the performance measurement for REL_17_STABLE (1e020258e) > and REL_16_STABLE (6f6b0f193) and found several benchmarks where v16 is > significantly better than v17. Please find attached an html table with > all the benchmarking results. Thanks for doing th

v17 vs v16 performance comparison

2024-07-31 Thread Alexander Lakhin
Hello hackers, I've repeated the performance measurement for REL_17_STABLE (1e020258e) and REL_16_STABLE (6f6b0f193) and found several benchmarks where v16 is significantly better than v17. Please find attached an html table with all the benchmarking results. I had payed attention to: Best pg-sr