| From: | Ryan Kelly <rpkelly22(at)gmail(dot)com> |
|---|---|
| To: | Stephen Frost <sfrost(at)snowman(dot)net> |
| Cc: | Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: PostgreSQL, OLAP, and Large Clusters |
| Date: | 2012-09-27 18:54:46 |
| Message-ID: | 20120927185446.GE25296@llserver.lakeliving.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Wed, Sep 26, 2012 at 09:15:35PM -0400, Stephen Frost wrote:
> All,
>
> * Scott Marlowe (scott(dot)marlowe(at)gmail(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Rob Sargent | 2012-09-27 19:05:15 | Re: PostgreSQL, OLAP, and Large Clusters |
| Previous Message | Ryan Kelly | 2012-09-27 18:50:03 | Re: PostgreSQL, OLAP, and Large Clusters |