Thread

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> — 2025-12-17T15:39:10Z

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