Re: PG for DataWarehouse type Queries

"Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us> writes:

> Ow Mun Heng <Ow(dot)Mun(dot)Heng(at)wdc(dot)com> writes:
>> 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)

One more question to pile on to the others: what version of Postgres is this.

I seem to recall some older versions had trouble with tables with hundreds of
columns, but that's just guessing in the dark without actual facts to look at.

--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com