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
[EMAIL PROTECTED]
(41) 3014 2322
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly