Finally !
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 !
Subscribe to:
Post Comments (Atom)
3x Faster TID Range Scans - Postgres 19
If you've ever had to scrub significantly large tables—whether updating older records or deleting expired ones—you know the pain of tryi...
-
(Please scroll down to the read the entire-post to know more) Documents required for Christian Marriage Registration (a.k.a. Documents... -
A recent commit to the PostgreSQL master branch brings a nice quality-of-life optimization for a very common SQL pattern - improving perform...
-
I am just starting my AI journey, and trying to get Ollama to work on my linux box, was an interesting non-AI experience. I noticed, that ev...
1 comment:
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.
http://www.dbrnd.com/2016/08/postgresql-multiple-group-by-using-grouping-sets-in-single-sql-query/
Post a Comment