Re: SLOPE - Planner optimizations on monotonic expressions.

From: Alexandre Felipe <o(dot)alexandre(dot)felipe(at)gmail(dot)com>
To: Dean Rasheed <dean(dot)a(dot)rasheed(at)gmail(dot)com>
Cc: Zsolt Parragi <zsolt(dot)parragi(at)percona(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-03-27 09:29:03
Message-ID: CAE8JnxOcnzLFDgPTBZDhKG9bsSemHrUJ6p-jKgM-NJ8bvzCFQg@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Fri, Mar 27, 2026 at 8:47 AM Dean Rasheed <dean(dot)a(dot)rasheed(at)gmail(dot)com>
wrote:

> I don't know. I haven't looked at the patches themselves in any
> detail. I was merely replying to a specific question about
> monotonicity with respect to a particular data type.
>
> However, my impression from reading this thread is that the patches
> haven't had a great deal of in-depth review yet, there are still a
> number of design ideas that people might wish to explore in more
> detail, it probably needs more careful analysis to verify correctness,
> and more testing. That makes me think that it's not feasible to get
> anything committable in less than a week, and it would be better to
> defer this.

Thank you for your feedback, either way I am happy that at least
now it received some attention.

I am testing an iterative single variable/expression and to find the
simplest expression x that is the cause of all the variation in the
pathkey expression, saving this in the plan info, and thus, reduce
the per index work.

Regards,
Alexandre

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Heikki Linnakangas 2026-03-27 09:45:56 Re: Clean up NamedLWLockTranche stuff
Previous Message shveta malik 2026-03-27 09:23:39 Re: Skipping schema changes in publication