Re: SLOPE - Planner optimizations on monotonic expressions.

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-11-06 11:41:43
Message-ID: CAE8JnxPeb859fz3ghPhJ1vov+bs8FrwQFb_Ht1_SNF4rp4fKTQ@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi,

This has been quiet for more than a month, now I decided to check
commitfest and I see a failure in test_plan_advice/001_replan_regress,
since I am touching planning it is reasonable to assume this to be a code
issue, however it happened only on windows.

Checking the history:
https://github.com/postgres/postgres-cfbot/actions?query=branch%3Acf%2F6479&page=2

There were a few sporadic failures.

What can explain that?

Regards,
Alexandre.

On Wed, Sep 23, 2026 at 9:25 AM Alexandre Felipe <
o(dot)alexandre(dot)felipe(at)gmail(dot)com> wrote:

> 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
>
>

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Alberto Piai 2026-11-06 12:36:11 Re: Adding a stored generated column without long-lived locks
Previous Message Xuneng Zhou 2026-11-06 11:15:48 Re: Call CalculateShmemSize() only once