On Wed, Sep 26, 2012 at 09:15:35PM -0400, Stephen Frost wrote:
> All,
>
> * Scott Marlowe (scott.marlowe@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