| From: | André Volpato <andre(dot)volpato(at)ecomtecnologia(dot)com(dot)br> |
|---|---|
| To: | Ow Mun Heng <Ow(dot)Mun(dot)Heng(at)wdc(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: PG for DataWarehouse type Queries |
| Date: | 2007-08-03 14:07:57 |
| Message-ID: | 46B336BD.2010200@ecomtecnologia.com.br |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Ow Mun Heng escreveu:
> Can anyone shed some light on this. I just would like to know if queries
> for raw data (not aggregregates) is expected to take a long time.
> Running times between 30 - 2 hours for large dataset pulls.
>
> Involves lots of joins on very large tables (min 1 millon rows each
> table, 300 columns per table)
>
> Joins are done in the form of Left joins (sometimes on the same tables,
> due to normalisation)
>
> Is 30min - 2hours too long or is this considered "normal"??
What do you mean for 'Datawarehouse queries' ?
Is there any OLAP server between youp app and Postrgres?
--
[]´s,
André Volpato
ECOM Tecnologia Ltda
andre(dot)volpato(at)ecomtecnologia(dot)com(dot)br
(41) 3014 2322
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2007-08-03 14:08:00 | Re: invalid page header |
| Previous Message | Tom Lane | 2007-08-03 13:59:30 | Re: PG for DataWarehouse type Queries |