Postgres Pro
Downloads
Home   >   mailing lists

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

From Michael Lewis
Subject Re: Is postgres able to share sorts required by common partition window functions?
Date
Msg-id CAHOFxGrhiXrATVHiMztJpyMzvsbdPYFMK-JO9O+1WokudiJj=w@mail.gmail.com
Whole thread Raw
In response to Is postgres able to share sorts required by common partition window functions?  (Sebastien Arod <sebastien.arod@gmail.com>)
Responses Re: Is postgres able to share sorts required by common partition window functions?
List pgsql-general
Tree view
Does this give the same result and do the optimization you want?

select
  c1,
  min(c2) AS c2,
  min(c3) AS c3,
  min(c4) AS c4
from  
  t
group by
  c1;

pgsql-general by date:

Previous
From: Michael Lewis
Date:
Subject: Re: Apply LIMIT when computation is logically irrelevant
Next
From: Sebastien Arod
Date:
Subject: Re: Is postgres able to share sorts required by common partition window functions?