Search Postgresql Archives
Re: Is postgres able to share sorts required by common partition window functions?
[
Date Prev
][
Date Next
][
Thread Prev
][
Thread Next
][
Date Index
][
Thread Index
]
Subject
: Re: Is postgres able to share sorts required by common partition window functions?
From
: Michael Lewis <mlewis@xxxxxxxxxxx>
Date
: Mon, 6 Jul 2020 13:55:00 -0600
Cc
: pgsql-general <pgsql-general@xxxxxxxxxxxxxx>
In-reply-to
: <
CADd42iFZWwYNsXjEM_3HWK3QnfiCrMNmpOkZqyBQCabnVxOPtw@mail.gmail.com
>
References
: <
CADd42iFZWwYNsXjEM_3HWK3QnfiCrMNmpOkZqyBQCabnVxOPtw@mail.gmail.com
>
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
;
[
Date Prev
][
Date Next
][
Thread Prev
][
Thread Next
][
Date Index
][
Thread Index
]
Follow-Ups
:
Re: Is postgres able to share sorts required by common partition window functions?
From:
Sebastien Arod
References
:
Is postgres able to share sorts required by common partition window functions?
From:
Sebastien Arod
Prev by Date:
Re: Apply LIMIT when computation is logically irrelevant
Next by Date:
Re: Apply LIMIT when computation is logically irrelevant
Previous by thread:
Is postgres able to share sorts required by common partition window functions?
Next by thread:
Re: Is postgres able to share sorts required by common partition window functions?
Index(es):
Date
Thread
[Index of Archives]
[Postgresql Jobs]
[Postgresql Admin]
[Postgresql Performance]
[Linux Clusters]
[PHP Home]
[PHP on Windows]
[Kernel Newbies]
[PHP Classes]
[PHP Books]
[PHP Databases]
[Postgresql & PHP]
[Yosemite]