Re: Performance of Query 60 on TPC-DS Benchmark

Nikita Malakhov <hukutoc@gmail.com>

From: Nikita Malakhov <hukutoc@gmail.com>

To: Andrei Lepikhov <lepihov@gmail.com>

Cc: Ba Jinsheng <bajinsheng@u.nus.edu>, "pgsql-performance@lists.postgresql.org" <pgsql-performance@lists.postgresql.org>

Date: 2024-11-29T14:27:18Z

Lists: pgsql-performance

Attachments

v1-0001-ppath-precheck.patch (application/octet-stream) patch v1-0001

Hi!

Please check the following proposal (patch in attach).
The main idea is to reject only obviously worse paths (costs considerably
more
than compared one), and to pass pre-calculated startup cost to precheck
function
for more accurate comparison.

>
> --
Regards,
Nikita Malakhov
Postgres Professional
The Russian Postgres Company
https://postgrespro.ru/