Re: Todo: Teach planner to evaluate multiple windows in the optimal order

Ankit Kumar Pandey <itsankitkp@gmail.com>

View thread View on postgr.es

From: Ankit Kumar Pandey <itsankitkp@gmail.com>

To: David Rowley <dgrowleyml@gmail.com>

Cc: pghackers <pgsql-hackers@lists.postgresql.org>

Date: 2023-01-04T15:11:27Z

Lists: pgsql-hackers

Attachments

v1-0001-add-test-cases-for-optimal-ordering-of-window-functi.patch (text/x-patch) patch v1-0001

Attaching test cases for this (+ small change in doc).

Tested this in one of WIP branch where I had modified 
select_active_windows and it failed

as expected.

Please let me know if something can be improved in this.


Regards,
Ankit Kumar Pandey

Commits

Split out tiebreaker comparisons from comparetup_* functions
- c9bfa40914be 17.0 landed
Add additional regression tests for select_active_windows
- a14a5832923e 16.0 landed