| From: | Herouth Maoz <herouth(at)unicell(dot)co(dot)il> |
|---|---|
| To: | Bartosz Dmytrak <bdmytrak(at)gmail(dot)com> |
| Cc: | cernst(at)zvelo(dot)com, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Up-to-date reports database |
| Date: | 2012-05-23 16:31:51 |
| Message-ID: | CC259A7C-EE29-4819-B940-498E83DA704B@unicell.co.il |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 23/05/2012, at 18:54, Bartosz Dmytrak wrote:
> hi,
> my suggestion is to redesign reporting database to fit reporting specifics (e.g. brake normal form of database, in some cases this will speed up reports). Than you can use some ETL tool to sync production and reporting. Good thing is to use some OLAP software to use multidimensional analyze - this will make queries easier (with MDX language). I think this kind of discussion is huge one :)
>
> there are some opensource ETL and BI suits available.
Thanks, I'll take that into consideration.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Mark Dilger | 2012-05-23 16:33:07 | Re: FATAL: lock file "postmaster.pid" already exists |
| Previous Message | Lonni J Friedman | 2012-05-23 16:12:47 | Re: Re: significant performance hit whenever autovacuum runs after upgrading from 9.0 -> 9.1 |