postgres for OLAP & data mining

On Fri, Sep 30, 2011 at 9:12 AM, Dario Beraldi <dario.beraldi@gmail.com>wrote:

Hello,

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.

Regards,

Many thanks in advance!

Dario

--
Cristian Salamea
@ovnicraft

Are you looking for stuff like this?

http://www.postgresql.org/docs/9.0/static/functions-window.html
http://www.postgresql.org/docs/9.0/static/functions-string.html

On Fri, Sep 30, 2011 at 10:12 AM, Dario Beraldi <dario.beraldi@gmail.com>wrote:

At 16:12 30/09/2011, Dario Beraldi wrote:

Hello,

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.

Check these tutorials:

http://pgexperts.com/document.html?id=49

http://www.pgexperts.com/document.html?id=40

There are more at http://www.pgexperts.com/presentations.html

YOu can check the presentations made on several pgcons and similar events

http://www.pgcon.org/2011/schedule/index.en.html

http://www.postgresopen.org/2011/home/

HTH

On 30 September 2011 18:41, Henry Drexler <alonup8tb@gmail.com> wrote:

Are you looking for stuff like this?

http://www.postgresql.org/docs/9.0/static/functions-window.html
http://www.postgresql.org/docs/9.0/static/functions-string.html

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).

Best
Dario