Postgres Pro
Downloads
Home   >   mailing lists

Re: Is postgres able to share sorts required by common partition window functions? - Mailing list pgsql-general

From David G. Johnston
Subject Re: Is postgres able to share sorts required by common partition window functions?
Date
Msg-id CAKFQuwbcpBiyChuXvzbTwRwX2jPqGj0ga3eoPexrvVtoUAMrsQ@mail.gmail.com
Whole thread Raw
In response to Re: Is postgres able to share sorts required by common partition window functions?  (Michael Lewis <mlewis@entrata.com>)
List pgsql-general
Tree view
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 by date:

Previous
From: Michael Lewis
Date:
Subject: Re: Is postgres able to share sorts required by common partition window functions?
Next
From: "David G. Johnston"
Date:
Subject: Re: Is postgres able to share sorts required by common partition window functions?