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

From: Michael Lewis <mlewis(at)entrata(dot)com>
To: Sebastien Arod <sebastien(dot)arod(at)gmail(dot)com>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Is postgres able to share sorts required by common partition window functions?
Date: 2020-07-06 19:55:00
Message-ID: CAHOFxGrhiXrATVHiMztJpyMzvsbdPYFMK-JO9O+1WokudiJj=w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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;

>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Sebastien Arod 2020-07-06 20:28:48 Re: Is postgres able to share sorts required by common partition window functions?
Previous Message Michael Lewis 2020-07-06 19:51:36 Re: Apply LIMIT when computation is logically irrelevant