PG for DataWarehouse type Queries - Mailing list pgsql-general

From Ow Mun Heng
Subject PG for DataWarehouse type Queries
Date
Msg-id 1186125170.14695.9.camel@neuromancer.home.net
Whole thread Raw
Responses Re: PG for DataWarehouse type Queries  ("Josh Tolley" <eggyknap@gmail.com>)
Re: PG for DataWarehouse type Queries  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: PG for DataWarehouse type Queries  (André Volpato<andre.volpato@ecomtecnologia.com.br>)
Re: PG for DataWarehouse type Queries  ("Simon Riggs" <simon@2ndquadrant.com>)
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