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