| From: | Alexandre Felipe <o(dot)alexandre(dot)felipe(at)gmail(dot)com> |
|---|---|
| To: | Zsolt Parragi <zsolt(dot)parragi(at)percona(dot)com> |
| Cc: | pgsql-hackers(at)lists(dot)postgresql(dot)org |
| Subject: | Re: SLOPE - Planner optimizations on monotonic expressions. |
| Date: | 2026-09-23 08:25:52 |
| Message-ID: | CAE8JnxPhoSoZN7HVRpd+Y9j883eSp+nCSM5O68e-cic5gc-VCw@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
v16.0
The previous version was producing sort in queries such as
SELECT x, f(y) FROM tbl WHERE x = 1 ORDER BY f(y);
Where the order of x is trivial as it is a constant for the query.
Regards,
Alexandre
| Attachment | Content-Type | Size |
|---|---|---|
| v16.0-0003-SLOPE-catalog-changes.patch | application/octet-stream | 94.5 KB |
| v16.0-0001-benchmark.patch | application/octet-stream | 4.8 KB |
| v16.0-0002-Optimized-reverse-pathkeys.patch | application/octet-stream | 7.1 KB |
| v16.0-0005-SLOPE-Constant-sort-keys.patch | application/octet-stream | 11.4 KB |
| v16.0-0004-SLOPE-Planner-support.patch | application/octet-stream | 78.6 KB |
| v16.0-0007-SLOPE-Timezone.patch | application/octet-stream | 54.0 KB |
| v16.0-0006-SLOPE-documentation.patch | application/octet-stream | 8.3 KB |
| v16.0-0008-SLOPE-timezone-errsave.patch | application/octet-stream | 12.0 KB |
| v16.0-0009-SLOPE-plan-cache-guards.patch | application/octet-stream | 12.9 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Thom Brown | 2026-09-23 08:26:22 | Re: REPACK (CONCURRENTLY) can silently lose updates when the toast table is rewritten |
| Previous Message | Zsolt Parragi | 2026-09-23 08:10:19 | Re: Serverside SNI support in libpq |