Re: Why doesn't Postgres apply limit on groups when retrieving N results per group using WHERE IN + ORDER BY

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: Why doesn't Postgres apply limit on groups when retrieving N results per group using WHERE IN + ORDER BY
Дата
Msg-id CAKFQuwZaoBwC9_fXsaiiU3i3hVSx+mZqabvC8mGUpaCNwk9a7g@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Why doesn't Postgres apply limit on groups when retrieving N results per group using WHERE IN + ORDER BY  (Ron Johnson <ronljohnsonjr@gmail.com>)
Ответы Re: Why doesn't Postgres apply limit on groups when retrieving N results per group using WHERE IN + ORDER BY
Список pgsql-general
Дерево обсуждения
On Mon, Feb 5, 2024 at 8:55 AM Ron Johnson <ronljohnsonjr@gmail.com> wrote:

Who knows which users are going to be in that list???


It doesn't matter.  Worse case scenario there is only one user in the result and so all 50 rows are their earliest 50 rows.  The system will thus never need more than the earliest 50 rows per user to answer this question.

David J.

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

Предыдущее
От: Ron Johnson
Дата:
Сообщение: Re: Why doesn't Postgres apply limit on groups when retrieving N results per group using WHERE IN + ORDER BY
Следующее
От: Ron Johnson
Дата:
Сообщение: Re: Unused indexes