A *much* awaited feature, this attempt at adding the GROUPING SETS / ROLLUP / CUBE feature to PostgreSQL has been in the works for about a year (besides the so many in the past decade and a half that didn't get through), and thankfully this has finally got the approval of the powers that be, so the upcoming Postgres 9.5 would finally have this long pending SQL feature.
MSSQL and Oracle have had this for a while and then its time that PostgreSQL sport this as well. A big boon for Report generating SQLs this feature basically makes (what was earlier possible with lots of unmanageable hack of SQL), now possible with much cleaner code, and with much better (at times single pass) performance.
Read here to know more about OLAP support in PostgreSQL.
Thanks a ton Andrew Gierth and Atri Sharma and so many others who directly or indirectly assisted in getting this patch out of the door!
Andrew / Atri... take that long pending break... one look at that mail thread and it seems you deserve it :D !
16 May 2015
Postgres finally has CUBE / ROLLUP / GROUPING SETS !
Subscribe to: Post Comments (Atom)
Find Database DNS / Endpoint via SQL
How to get Database identifier using SQL Often there is a need for client programs to find "where am I logged into?". This blog po...
My patch (allowing a non-super-user to dump Globals) just got committed to Postgres 10.0. Besides the use mentioned above, this patch al...
(Please scroll down to the read the entire-post to know more) Documents required for Christian Marriage Registration (a.k.a. Documents...
Recently got an additional monitor for my workstation@home and found that the following wires were indispensable: USB Mouse Monitor VGA ...
Nice Article !
This is my pleasure to read your article.
Really this will help to people of PostgreSQL Community.
I have also prepared one article about, PostgreSQL Grouping Sets.
You can also visit my article, your comments and reviews are most welcome.
Post a Comment