Re: BUG #19449: Massive performance degradation for complex query on Postgres 16+ (few seconds -> multiple hours)

Adrian Mönnich <adrian.moennich@cern.ch>

From: Adrian Mönnich <adrian.moennich@cern.ch>

To: Tomas Vondra <tomas@vondra.me>, Andres Freund <andres@anarazel.de>

Cc: pgsql-bugs@lists.postgresql.org, Tomas Vondra <tv@fuzzy.cz>, Thomas Munro <thomas.munro@gmail.com>

Date: 2026-05-19T10:10:44Z

Lists: pgsql-bugs

Hi,

just wondering, when this gets fixed, will the fix only go into the latest
master version, or also get backported to other still-supported versions?

Cheers,
Adrian

Commits

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

Improve hash join's handling of tuples with null join keys.
- 1811f1af98fb 19 (unreleased) cited
Parallel Hash Full Join.
- 11c2d6fdf5af 16.0 cited