Horton
Menu

Re: BUG #19493: Assertion failure in pg_plan_advice with EXISTS subquery and DO_NOT_SCAN advice

Michael Paquier <michael@paquier.xyz>

View thread
From: Michael Paquier <michael@paquier.xyz>
To: Pierre Forstmann <pierre.forstmann@gmail.com>
Cc: n.kalinin@postgrespro.ru, pgsql-bugs@lists.postgresql.org, PG Bug reporting form <noreply@postgresql.org>
Date: 2026-05-27T00:49:55Z
Lists: pgsql-bugs 
On Tue, May 26, 2026 at 07:52:03PM +0200, Pierre Forstmann wrote:
> I am not sure pg_plan_advice is supported with PG 18.4 ?

Nope, the module is not supported on 18.4.

> I cannot reproduce with latest commit from PG 19 master branch:

But if you can find a problem while testing the module only on HEAD,
that would be a bug we would need to take care of.
--
Michael

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →

  1. pg_plan_advice: DO_NOT_SCAN is a simple tag, not a generic one.

  2. doc: add comma to UPDATE docs, for consistency

  3. Add stack depth check to QueueFKConstraintValidation().