| From: | Zsolt Parragi <zsolt(dot)parragi(at)percona(dot)com> |
|---|---|
| To: | Alexandre Felipe <o(dot)alexandre(dot)felipe(at)gmail(dot)com> |
| Cc: | Dean Rasheed <dean(dot)a(dot)rasheed(at)gmail(dot)com>, Corey Huinker <corey(dot)huinker(at)gmail(dot)com>, pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: SLOPE - Planner optimizations on monotonic expressions. |
| Date: | 2026-05-08 22:18:55 |
| Message-ID: | CAN4CZFP+QkhGnt60_Z+QoaPj1nVfNtGFQhLtFxp_bTJ6SbMOMQ@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
> There were too many possibilities for my brain to enumerate, so I scripted
> the
> extraction and presentation of that in regress/sql/slope.sql in commit 0005.
Apologies, I forgot to reply to this earlier, the new NULL handling
looks good. Nice test!
I found one more corner case with infinities (same applies also with
negative infinity):
CREATE TABLE t8 (x float8);
INSERT INTO t8 VALUES (-2), (-1), (0), (1), (2);
CREATE INDEX t8_x_idx ON t8 (x);
ANALYZE t8;
SET enable_seqscan = off;
SELECT x, x * 'Infinity'::float8 AS f FROM t8 ORDER BY x * 'Infinity'::float8;
SET enable_indexscan = off;
SET enable_indexonlyscan = off;
SET enable_seqscan = on;
SELECT x, x * 'Infinity'::float8 AS f FROM t8 ORDER BY x * 'Infinity'::float8;
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael Paquier | 2026-05-08 23:00:56 | Re: [PATCH] Free BufFile metadata in close and append paths |
| Previous Message | Cary Huang | 2026-05-08 21:36:10 | Re: Add ssl_(supported|shared)_groups to sslinfo |