Re: Drill-downs and OLAP type data - Mailing list pgsql-general

From Craig Ringer
Subject Re: Drill-downs and OLAP type data
Date
Msg-id 4E951CFB.2030500@ringerc.id.au
Whole thread Raw
In response to Drill-downs and OLAP type data  (Anthony Presley <anthony@resolution.com>)
List 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

pgsql-general by date:

Previous
From: Craig Ringer
Date:
Subject: Re: I need to load mysql dump to postgres...
Next
From: Stephen Cook
Date:
Subject: Re: 7