Re: Optimize SELECT * in EXISTS

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Peter Eisentraut <peter(at)eisentraut(dot)org>
Cc: David Rowley <dgrowleyml(at)gmail(dot)com>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Optimize SELECT * in EXISTS
Date: 2026-02-24 21:07:39
Message-ID: 4037351.1771967259@sss.pgh.pa.us
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Peter Eisentraut <peter(at)eisentraut(dot)org> writes:
> It appears so, but then I think we should update the documentation along
> the lines I showed, because I found it misleading about this. New
> docs-only patch attached.

+1 for being more explicit here, but that specific wording reads a
little awkwardly to me. What do you think of the attached?

(The new code comments are fine, I didn't touch them.)

regards, tom lane

Attachment Content-Type Size
v3-0001-doc-Document-SELECT-in-EXISTS-optimizations.patch text/x-diff 2.3 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Ilia Evdokimov 2026-02-24 21:14:01 Re: Reduce planning time for large NOT IN lists containing NULL
Previous Message Tom Lane 2026-02-24 20:40:38 Re: pgsql: libpq: Grease the protocol by default