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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general