Pgsql: Support Grouping Sets, Cube, and Rollup (opens in new tab)

It's on the developer version docs: http://www.postgresql.org/docs/devel/static/queries-table-ex...

Maybe ping depesz (http://www.depesz.com/) about it. He has that great "waiting for postgres X.X" column at his blog, where he illustrates new things.

It's a commit message, not the docs though ;).

SSAS and other cube (MOLAP) tools create persistent cubes as materialized views. Databases that do ROLAP processing create "cubes on the fly" which persist for the duration of the query.

If PG adopts a materialized view that supports controlled automatic maintenance, then you'd have something similar to what the MOLAP tools do.

Note that MOLAP is a trap of sorts (no pun intended).

You could before. The benefit of OLAP databases and other analytical engines is only partly due to the focus of the query languages. Storage format, and calculation engine requirements are vastly different between OLTP and OLAP.

While the constructs in the linked article increase the expressive power of SQL, they are more icing than cake for an OLAP load.

> Everyone should abandon all other databases that don't have special features (ex: sqlite embedded).

SQLite embedded does have special features. It's embedded.

Just added a line to that page saying it's in, :)

I am a huge fan and advocate of PG but just for some perspective: CUBE and ROLLUP were present in SQL Server in the '90s.