Quick Links

Re: BUG #19357: PostgreSQL generates a custom plan that performs worse than the generic plan for a certain query.

From:	Greg Sabino Mullane <htamfids(at)gmail(dot)com>
To:	798604270(at)qq(dot)com, pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject:	Re: BUG #19357: PostgreSQL generates a custom plan that performs worse than the generic plan for a certain query.
Date:	2025-12-17 14:54:08
Message-ID:	CAKAnmmKVs-xCtsoF9Y5hAGavfXSGo2_2T=R19CcYArZ7MC7uKA@mail.gmail.com
Views:	Whole Thread \| Raw Message \| Download mbox \| Resend email
Thread:
Lists:	pgsql-bugs

Please simplify your test query as much as possible and use "text" format
in your explain results; those will improve your chances of getting a
useful reply. :)

In response to

BUG #19357: PostgreSQL generates a custom plan that performs worse than the generic plan for a certain query. at 2025-12-17 06:57:30 from PG Bug reporting form

Responses

Re: BUG #19357: PostgreSQL generates a custom plan that performsworse than the generic plan for a certain query. at 2025-12-17 15:17:30 from ZhangChi
Re: BUG #19357: PostgreSQL generates a custom plan that performs worse than the generic plan for a certain query. at 2025-12-17 15:39:10 from Tom Lane

Browse pgsql-bugs by date

	From	Date	Subject
Next Message	Laurenz Albe	2025-12-17 15:14:11	Re: Possible performance issues: DISTINCT ON + ORDER BY and JIT with aggregation
Previous Message	Greg Sabino Mullane	2025-12-17 14:51:08	Re: BUG #19350: Short circuit optimization missed when runningsqlscriptes in JDBC