Re: Hook for Selectivity Estimation in Query Planning

From: Aleksander Alekseev <aleksander(at)timescale(dot)com>
To: PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Cc: Andrei Lepikhov <lepihov(at)gmail(dot)com>
Subject: Re: Hook for Selectivity Estimation in Query Planning
Date: 2025-03-05 13:29:51
Message-ID: CAJ7c6TNiLhVELeX7MJ_KP8x21+9RqJ1uCg4dJukiwJ4ARBFBuQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi,

> I would like to discuss the introduction of a hook for evaluating the
> selectivity of an expression when searching for an optimal query plan.
> This topic has been brought up in various discussions, for example, in [1].
>
> [...]

As I vaguely recall recent proposals like this ("Pluggable TOASTer" to
name one) this approach was criticised. Hooks per se don't add value
for the end user. They only put the burden of maintaining them on the
community while all the real features are implemented in proprietar
extensions. If you believe something is missing in Postgres,
contribute it to the upstream so that anyone will benefit from it.

Personally I agree with the sentiment, thus -1.

--
Best regards,
Aleksander Alekseev

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message 258790519 2025-03-05 13:30:33 Re: is git.postgresql.org working fine?
Previous Message Aleksander Alekseev 2025-03-05 13:17:34 Re: is git.postgresql.org working fine?