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

Tom Lane <tgl@sss.pgh.pa.us>

From: Tom Lane <tgl@sss.pgh.pa.us>
To: Greg Sabino Mullane <htamfids@gmail.com>
Cc: 798604270@qq.com, pgsql-bugs@lists.postgresql.org
Date: 2025-12-17T15:39:10Z
Lists: pgsql-bugs
Greg Sabino Mullane <htamfids@gmail.com> writes:
> 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. :)

More to the point: it's hard to get excited about optimizing a query
that was so obviously built by a fuzzer rather than corresponding to
any real-world use-case.  We have finite manpower and we'd much rather
put it into solving users' real problems.

			regards, tom lane