PG for DataWarehouse type Queries - Mailing list pgsql-general

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"??



pgsql-general by date:

Previous
From: "Sergey Moroz"
Date:
Subject: Re: parsed queries (cursors) cashing issues
Next
From: mljv@planwerk6.de
Date:
Subject: Re: pgpool2 vs sequoia