Re: Why percent_rank is so slower than rank?

Поиск
Список
Период
Сортировка
От Ron Mayer
Тема Re: Why percent_rank is so slower than rank?
Дата
Msg-id 4D068A6D.9090402@cheapcomplexdevices.com
обсуждение исходный текст
Ответ на Re: Why percent_rank is so slower than rank?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
Tom Lane wrote:
> argue that there was a regression.  It's certainly a performance bug
> though: nobody would expect that giving a query *more* work_mem would
> cause it to run many times slower.

I wouldn't be that surprised - otherwise it'd just be hard-coded to
something large.

Especially since earlier in the thread:
> The example is *not* particularly slow if you leave work_mem at default.
which makes me think it's arguably not quite a bug.




В списке pgsql-hackers по дате отправления:

Предыдущее
От: Pavel Stehule
Дата:
Сообщение: Re: hstores in pl/python
Следующее
От: Dimitri Fontaine
Дата:
Сообщение: Re: CommitFest wrap-up