Thread: CUBE, ROLLUP, GROUPING SETS?
Hi. Are there any plans to implement CUBE, ROLLUP and/or GROUPING SETS in future PostgreSQL versions? I could not find any info on the TODO-page. /stig
On Tuesday 10 October 2006 15:19, stig erikson wrote:
> Hi.
> Are there any plans to implement CUBE, ROLLUP and/or GROUPING SETS in
> future PostgreSQL versions? I could not find any info on the TODO-page.
>
I've heard people mention it, but no one has ever come up with a solid
proposal or patch. Depending on what your doing there are ways to simulate
those things with more standard sql.
--
Robert Treat
Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL
2006/10/28, Robert Treat <xzilla@users.sourceforge.net>: > On Tuesday 10 October 2006 15:19, stig erikson wrote: > >> Are there any plans to implement CUBE, ROLLUP and/or GROUPING SETS in >> future PostgreSQL versions? I could not find any info on the TODO-page. > > I've heard people mention it, but no one has ever come up with a solid > proposal or patch. Depending on what your doing there are ways to simulate > those things with more standard sql. CUBE, ROLLUP and GROUPING SETS are at least part of SQL 2003. Supporting them would probably also include optimized ways to execute them, like calculating all aggregations in one run for ROLLUP (instead of doing multiple scans). greetings, Nicolas -- Nicolas Barbier http://www.gnu.org/philosophy/no-word-attachments.html
On Saturday 28 October 2006 19:47, Nicolas Barbier wrote:
> 2006/10/28, Robert Treat <xzilla@users.sourceforge.net>:
> > On Tuesday 10 October 2006 15:19, stig erikson wrote:
> >> Are there any plans to implement CUBE, ROLLUP and/or GROUPING SETS in
> >> future PostgreSQL versions? I could not find any info on the TODO-page.
> >
> > I've heard people mention it, but no one has ever come up with a solid
> > proposal or patch. Depending on what your doing there are ways to
> > simulate those things with more standard sql.
>
> CUBE, ROLLUP and GROUPING SETS are at least part of SQL 2003.
> Supporting them would probably also include optimized ways to execute
> them, like calculating all aggregations in one run for ROLLUP (instead
> of doing multiple scans).
>
I didn't say anyone was against the idea, just that we've yet to see someone
with the appropriately shaped tuits show up...
--
Robert Treat
Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL
Centuries ago, Nostradamus foresaw when nicolas.barbier@gmail.com ("Nicolas Barbier") would write:
> 2006/10/28, Robert Treat <xzilla@users.sourceforge.net>:
>
>> On Tuesday 10 October 2006 15:19, stig erikson wrote:
>>
>>> Are there any plans to implement CUBE, ROLLUP and/or GROUPING SETS in
>>> future PostgreSQL versions? I could not find any info on the TODO-page.
>>
>> I've heard people mention it, but no one has ever come up with a
>> solid proposal or patch. Depending on what your doing there are
>> ways to simulate those things with more standard sql.
>
> CUBE, ROLLUP and GROUPING SETS are at least part of SQL 2003.
> Supporting them would probably also include optimized ways to
> execute them, like calculating all aggregations in one run for
> ROLLUP (instead of doing multiple scans).
I'm sure a good implementation would include such things.
I'm not sure it's anywhere near trivial to do so; it may be nontrivial
to efficiently do all those aggregates at once. We'll presumably
discover this if and when someone begins work on it...
--
"cbbrowne","@","gmail.com"
http://linuxdatabases.info/info/postgresql.html
"In the long run every program becomes rococo - then rubble."
-- Alan Perlis
Christopher Browne wrote:
> Centuries ago, Nostradamus foresaw when nicolas.barbier@gmail.com ("Nicolas Barbier") would write:
> > 2006/10/28, Robert Treat <xzilla@users.sourceforge.net>:
> >
> >> On Tuesday 10 October 2006 15:19, stig erikson wrote:
> >>
> >>> Are there any plans to implement CUBE, ROLLUP and/or GROUPING SETS in
> >>> future PostgreSQL versions? I could not find any info on the TODO-page.
> >>
> >> I've heard people mention it, but no one has ever come up with a
> >> solid proposal or patch. Depending on what your doing there are
> >> ways to simulate those things with more standard sql.
> >
> > CUBE, ROLLUP and GROUPING SETS are at least part of SQL 2003.
> > Supporting them would probably also include optimized ways to
> > execute them, like calculating all aggregations in one run for
> > ROLLUP (instead of doing multiple scans).
>
> I'm sure a good implementation would include such things.
>
> I'm not sure it's anywhere near trivial to do so; it may be nontrivial
> to efficiently do all those aggregates at once. We'll presumably
> discover this if and when someone begins work on it...
Our TODO has:
* Add ROLLUP, CUBE, GROUPING SETS options to GROUP BY
--
Bruce Momjian bruce@momjian.us
EnterpriseDB http://www.enterprisedb.com
+ If your life is a hard drive, Christ can be your backup. +
Apologies for raising this thread back from the dead - Zombie thread if you like! Very interested in the Rollup and Cube OLAP fuinctions :) Does anyone know where this todo is in current plans. I've searched the archives but the last patch I could find was from 2008... Marc -- View this message in context: http://postgresql.1045698.n5.nabble.com/GENERAL-CUBE-ROLLUP-GROUPING-SETS-tp1868659p4810233.html Sent from the PostgreSQL - general mailing list archive at Nabble.com.