On Wed, Sep 26, 2012 at 09:15:35PM -0400, Stephen Frost wrote: > All, > > * Scott Marlowe (scott.marl...@gmail.com) wrote: > > If you want fastish OLAP on postgres you need to do several things. > [...] > > All good suggestions. > > I'd recommend looking at ROLAP approaches and doing aggregations and > materialized views first.. Will depend on exactly what you need/are > looking to do with the data, of course. We currently do a lot of materialized views, unfortunately even that is starting to get somewhat slow.
Some queries continue to be ad-hoc and probably can't be solved with a materialized approach. > > Thanks, > > Stephen Thanks, -Ryan Kelly
signature.asc
Description: Digital signature
