Re: Is postgres able to share sorts required by common partition window functions?

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: Is postgres able to share sorts required by common partition window functions?
Дата
Msg-id CAKFQuwbcpBiyChuXvzbTwRwX2jPqGj0ga3eoPexrvVtoUAMrsQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Is postgres able to share sorts required by common partition window functions?  (Michael Lewis <mlewis@entrata.com>)
Список pgsql-general
Дерево обсуждения
On Monday, July 6, 2020, Michael Lewis <mlewis@entrata.com> wrote:
Did you say you have an index on c1?
[...]
I don't know the data, but I assume there may be many rows with the same c1 value, so then you would likely benefit from getting that distinct set first like below as your FROM table.

Re-reading the original email I see both the answer to your question and the data being queried.

David J.

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

Предыдущее
От: Michael Lewis
Дата:
Сообщение: Re: Is postgres able to share sorts required by common partition window functions?
Следующее
От: "David G. Johnston"
Дата:
Сообщение: Re: Is postgres able to share sorts required by common partition window functions?