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

Поиск
Список
Период
Сортировка
От Greg Sabino Mullane
Тема Re: BUG #19357: PostgreSQL generates a custom plan that performsworsethan the generic plan for a certain query.
Дата
Msg-id CAKAnmmKd0k7VzLkpF7SXQt+YToA0m0dKruqBW4XXjJsS5gwA+Q@mail.gmail.com
обсуждение исходный текст
Ответ на Re: BUG #19357: PostgreSQL generates a custom plan that performsworsethan the generic plan for a certain query.  ("ZhangChi" <798604270@qq.com>)
Список 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 по дате отправления: