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.
IMHO what you need is in logic layer software is not in data layer.