SLOPE - Planner optimizations on monotonic expressions.

Edit
ID 6479
Title SLOPE - Planner optimizations on monotonic expressions.
CI (CFBot) Summary
Stats (from CFBot) Patch count: 8, First patch: +138−0, All patches: +4289−281
Tags Performance
Created 2026-02-12 07:57:17
Last modified 2026-08-01 00:00:09 (1 month ago)
Latest email 2026-09-17 06:27:47 (3 days ago)
Status
PG20-2 (2026-09-01 – 2026-09-30): Needs review
PG20-1 (2026-07-01 – 2026-07-31): Moved to different CF
PG19-Final (2026-03-01 – 2026-04-09): Moved to different CF
Target version
Authors Alexandre Felipe (afelipe)
Reviewers Corey Huinker (coreyh), Zsolt Parragi (zsolt.parragi) Become reviewer
Committer
Links
Emails
SLOPE - Planner optimizations on monotonic expressions.
First at 2026-02-11 21:02:53 by Alexandre Felipe <o.alexandre.felipe at gmail.com>
Latest at 2026-09-17 06:27:47 by Alexandre Felipe <o.alexandre.felipe at gmail.com>
Latest attachment (v15.5-0002-Optimized-reverse-pathkeys.patch) at 2026-09-17 06:27:47 from Alexandre Felipe <o.alexandre.felipe at gmail.com>
    Attachment (v15.5-0002-Optimized-reverse-pathkeys.patch) at 2026-09-17 06:27:47 from Alexandre Felipe <o.alexandre.felipe at gmail.com> (Patch: No)
    Attachment (v15.4-0004-SLOPE-Planner-support.patch) at 2026-09-14 21:10:01 from Alexandre Felipe <o.alexandre.felipe at gmail.com> (Patch: No)
    Attachment (tzbreak.sql) at 2026-09-01 10:27:22 from Alexandre Felipe <o.alexandre.felipe at gmail.com> (Patch: No)
    Attachment (v15.2-0003-SLOPE-catalog-changes.patch) at 2026-08-24 19:16:52 from Alexandre Felipe <o.alexandre.felipe at gmail.com> (Patch: No)
    Attachment (v15.1-0004-SLOPE-Planner-support.patch) at 2026-08-24 08:19:13 from Alexandre Felipe <o.alexandre.felipe at gmail.com> (Patch: No)
    Attachment (v15-0001-benchmark.patch) at 2026-08-23 21:14:39 from Alexandre Felipe <o.alexandre.felipe at gmail.com> (Patch: No)
    Attachment (v14-0005-SLOPE-documentation.patch) at 2026-08-05 18:09:31 from Alexandre Felipe <o.alexandre.felipe at gmail.com> (Patch: No)
    Attachment (v13-0002-Optimized-reverse-pathkeys.patch) at 2026-07-27 07:00:34 from Alexandre Felipe <o.alexandre.felipe at gmail.com> (Patch: No)
    Attachment (v12-0005-SLOPE-documentation.patch) at 2026-07-20 19:21:57 from Alexandre Felipe <o.alexandre.felipe at gmail.com> (Patch: No)
    Attachment (v11-0002-Optimized-reverse-pathkeys.patch) at 2026-07-19 13:26:04 from Alexandre Felipe <o.alexandre.felipe at gmail.com> (Patch: No)
    Attachment (v10-0002-Optimized-reverse-pathkeys.patch) at 2026-07-16 19:51:33 from Alexandre Felipe <o.alexandre.felipe at gmail.com> (Patch: No)
    Attachment (v9-0003-SLOPE-prosupport-definitions.patch) at 2026-07-03 10:02:30 from Alexandre Felipe <o.alexandre.felipe at gmail.com> (Patch: Yes)
    Attachment (v8-0003-SLOPE-prosupport-definitions.patch) at 2026-06-01 13:07:47 from Alexandre Felipe <o.alexandre.felipe at gmail.com> (Patch: Yes)
    Attachment (slope_corner_cases.sql) at 2026-05-10 15:53:49 from Alexandre Felipe <o.alexandre.felipe at gmail.com> (Patch: No)
    Attachment (v8-0002-Optimized-reverse-pathkeys.patch) at 2026-05-07 19:12:25 from Alexandre Felipe <o.alexandre.felipe at gmail.com> (Patch: Yes)
    Attachment (v7-0001-benchmark.patch) at 2026-04-13 16:38:50 from Alexandre Felipe <o.alexandre.felipe at gmail.com> (Patch: Yes)
    Attachment (v7-0004-SLOPE-catalog-changes.patch) at 2026-04-13 06:22:22 from Alexandre Felipe <o.alexandre.felipe at gmail.com> (Patch: Yes)
    Attachment (v7-0002-Optimized-reverse-pathkeys.patch) at 2026-04-12 15:01:52 from Alexandre Felipe <o.alexandre.felipe at gmail.com> (Patch: Yes)
    Attachment (v6-0002-Optimized-reverse-pathkeys.patch) at 2026-04-06 08:29:34 from Alexandre Felipe <o.alexandre.felipe at gmail.com> (Patch: Yes)
    Attachment (v6-0001-benchmark.patch) at 2026-04-05 21:28:35 from Alexandre Felipe <o.alexandre.felipe at gmail.com> (Patch: Yes)
    Attachment (v5-0002-SLOPE-Builtin-support.patch) at 2026-03-26 09:51:56 from Alexandre Felipe <o.alexandre.felipe at gmail.com> (Patch: Yes)
    Attachment (v4-0001-SLOPE-Analysis-Machinery.patch) at 2026-03-25 23:34:40 from Alexandre Felipe <o.alexandre.felipe at gmail.com> (Patch: Yes)
    Attachment (v3-0001-SLOPE-Analysis-Machinery.patch) at 2026-03-25 14:47:58 from Alexandre Felipe <o.alexandre.felipe at gmail.com> (Patch: Yes)
    Attachment (v2-0003-SLOPE-Tests.patch) at 2026-03-20 06:53:32 from Alexandre Felipe <o.alexandre.felipe at gmail.com> (Patch: Yes)
    Attachment (0002-SLOPE-Builtin-support.patch) at 2026-02-11 21:02:53 from Alexandre Felipe <o.alexandre.felipe at gmail.com> (Patch: Yes)
History
When Who What
2026-09-17 06:41:47 CFbot Patch does not need rebase anymore
2026-09-16 15:12:17 CFbot Patch needs rebase
2026-09-14 21:31:39 CFbot Patch does not need rebase anymore
2026-09-08 06:59:35 CFbot Patch needs rebase
2026-08-01 00:00:09 CFbot Moved from CF PG20-1 to CF PG20-2
2026-05-07 19:42:37 CFbot Patch does not need rebase anymore
2026-05-01 17:40:27 CFbot Patch needs rebase
2026-04-10 00:00:06 CFbot Moved from CF PG19-Final to CF PG20-1
2026-04-06 23:09:09 Zsolt Parragi (zsolt.parragi) Added zsolt.parragi as reviewer
2026-04-06 08:40:36 CFbot Patch does not need rebase anymore
2026-03-31 09:30:32 CFbot Patch needs rebase
2026-03-25 04:02:25 Corey Huinker (coreyh) Added coreyh as reviewer
2026-02-18 21:51:03 Alexandre Felipe (afelipe) Posted comment with messageid <177145146356.628.9602820388536326984.pgcf@coridan.postgresql.org>
2026-02-12 07:57:17 Alexandre Felipe (afelipe) Attached mail thread CAE8JnxN8kLUMygXb33LC-UPGyTC0cTcCyeWUdfEoz=OBo3aT5g@mail.gmail.com
2026-02-12 07:57:17 Alexandre Felipe (afelipe) Created patch record
Edit