PG for DataWarehouse type Queries
От
Ow Mun Heng
Тема
PG for DataWarehouse type Queries
Дата
Msg-id
1186125170.14695.9.camel@neuromancer.home.net
Список
Дерево обсуждения
PG for DataWarehouse type Queries Ow Mun Heng <Ow.Mun.Heng@wdc.com>
Re: PG for DataWarehouse type Queries "Simon Riggs" <simon@2ndquadrant.com>
Re: PG for DataWarehouse type Queries André Volpato<andre.volpato@ecomtecnologia.com.br>
Re: PG for DataWarehouse type Queries Tom Lane <tgl@sss.pgh.pa.us>
Re: PG for DataWarehouse type Queries Gregory Stark <stark@enterprisedb.com>
Re: PG for DataWarehouse type Queries "Josh Tolley" <eggyknap@gmail.com>
Re: PG for DataWarehouse type Queries Ow Mun Heng <Ow.Mun.Heng@wdc.com>
Re: PG for DataWarehouse type Queries Tom Lane <tgl@sss.pgh.pa.us>
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 по дате отправления
