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

From Tom Lane
Subject Re: BUG #19357: PostgreSQL generates a custom plan that performs worse than the generic plan for a certain query.
Date
Msg-id 2628965.1765985950@sss.pgh.pa.us
Whole thread Raw
In response to Re: BUG #19357: PostgreSQL generates a custom plan that performs worse than the generic plan for a certain query.  (Greg Sabino Mullane <htamfids@gmail.com>)
Responses Re: BUG #19357: PostgreSQL generates a custom plan that performs worse than the generic plan for a certain query.
List 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



pgsql-bugs by date:

Previous
From: Dave Cramer
Date:
Subject: Re: BUG #19350: Short circuit optimization missed when runningsqlscriptes in JDBC
Next
From: Dave Cramer
Date:
Subject: Re: BUG #19350: Short circuit optimization missed when runningsqlscriptes in JDBC