public inbox for [email protected]  

help / color / mirror / Atom feed

From: Hans Buschmann <[email protected]>
To: [email protected] <[email protected]>
To: Tom Lane <[email protected]>
Subject: Re: Making Vars outer-join aware
Date: Tue, 24 Jan 2023 10:11:00 +0000
Message-ID: <[email protected]> (raw)

Hello Tom


I just noticed your new efforts in this area.


I wanted to recurr to my old thread [1] considering constant propagation of quals.


You gave an elaborated explanation at that time, but my knowledge was/is not yet sufficient to reveil the technical details.


In our application the described method is widespread used with much success (now at pg15.1 Fedora), but for unexperienced SQL authors this is not really obviously to choose (i.e. using the explicit constant xx_season=3 as qual). This always requires a "Macro" processor to compose the queries (in my case php) and a lot of programmer effort in the source code.


I can't review/understand your patchset for the planner, but since it covers the same area, the beformentioned optimization could perhaps be addressed too.


With respect of the nullability of these quals I immediately changed all of them to NOT NULL, which seems the most natural way when these quals are also used for partioning.


[1]  https://www.postgresql.org/message-id/[email protected]


Thanks for looking


Hans Buschmann

view thread (2+ messages)

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected]
  Subject: Re: Making Vars outer-join aware
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox