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

From Greg Sabino Mullane
Subject Re: BUG #19357: PostgreSQL generates a custom plan that performsworsethan the generic plan for a certain query.
Date
Msg-id CAKAnmmKd0k7VzLkpF7SXQt+YToA0m0dKruqBW4XXjJsS5gwA+Q@mail.gmail.com
Whole thread Raw
In response to Re: BUG #19357: PostgreSQL generates a custom plan that performsworsethan the generic plan for a certain query.  ("ZhangChi" <798604270@qq.com>)
List pgsql-bugs
Everything in the second query is slightly faster (and heavy emphasis on "slightly") - it could simply be caching at some level. Run each query multiple times and interleave them for better results. However, we are now discussing that a query runs in .017ms versus .033ms. Add some real data and demonstrate something that would trigger a real-world concern. Nobody is going to get excited about microsecond differences. At that level, it's near impossible to distinguish anything due to the overall noise and effects of things out of Postgres' control. In short, not a bug, unless you can demonstrate otherwise. :) 


Cheers,
Greg

pgsql-bugs by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: BUG #19357: PostgreSQL generates a custom plan thatperformsworsethan the generic plan for a certain query.
Next
From: Tom Lane
Date:
Subject: Re: BUG #19358: Short circuit optimization exists in generic plan but missed in custom plan