Re: SLOPE - Planner optimizations on monotonic expressions.

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;

In response to

Browse pgsql-hackers by date

  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