Re: Should we optimize the `ORDER BY random() LIMIT x` case?

Поиск
Список
Период
Сортировка
От Nico Williams
Тема Re: Should we optimize the `ORDER BY random() LIMIT x` case?
Дата
Msg-id aCtQa0CzPtHWolXH@ubby
обсуждение исходный текст
Ответ на Re: Should we optimize the `ORDER BY random() LIMIT x` case?  (Aleksander Alekseev <aleksander@timescale.com>)
Список pgsql-hackers
On Mon, May 19, 2025 at 01:25:00PM +0300, Aleksander Alekseev wrote:
> I agree this would be most convenient for the user. Unfortunately this
> will require us to check every SELECT query: "oh, isn't it by any
> chance ORDER BY random() LIMIT x?". I don't think we can't afford such
> a performance degradation, even a small one, for an arguably rare
> case.

Can the detection of such queries be done by the yacc/bison parser
grammar?

Nico
-- 



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