Thanks for reply. Yes, I knew these functions. In fact, I was rather wondering whether there are dedicated packages for OLAP and some guidelines for configuring postgres (and whether postgres is a good option for OLAP).
I'm looking for some information (guidelines, docs, tutorials, etc...) about using postgres for OLAP, data mining, data warehousing. The sort of questions I'm trying to answer are on the lines of - What tools/SQL commands are available? - How should postgres be configured? - How suitable is postgres for these tasks (compared to other databases)?
I have done some Google search but I would appreciate any advice/hint from more experienced users.
