Re: Drill-downs and OLAP type data

From: Craig Ringer <ringerc(at)ringerc(dot)id(dot)au>
To: Anthony Presley <anthony(at)resolution(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Drill-downs and OLAP type data
Date: 2011-10-12 04:52:11
Message-ID: 4E951CFB.2030500@ringerc.id.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 10/12/2011 11:50 AM, Anthony Presley wrote:

> What's the PG route here? Are there some secrets / tips / tricks /
> contrib modules for handling this?

I don't see much discussion of DW, OLAP-type workloads here. Pg doesn't
support index-oriented tables (though IIRC 9.2 will add covering indexes
- yay!), column-oriented storage, or other features that're pretty basic
to OLAP workloads.

Have you looked at Greenplum?

--
Craig Ringer

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Stephen Cook 2011-10-12 05:06:56 Re: 7
Previous Message Craig Ringer 2011-10-12 04:50:26 Re: I need to load mysql dump to postgres...