Re: PG for DataWarehouse type Queries

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Ow Mun Heng <Ow(dot)Mun(dot)Heng(at)wdc(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: PG for DataWarehouse type Queries
Date: 2007-08-06 02:10:12
Message-ID: 8581.1186366212@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Ow Mun Heng <Ow(dot)Mun(dot)Heng(at)wdc(dot)com> writes:
> Queries involves 11 Joins (of 5 Main tables, of which 3 are Large, 2 are
> fact tables)

It would be a good idea to increase join_collapse_limit to more than 11.
This will increase the planning time, but the investment will likely be
worthwhile for such a large query.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2007-08-06 02:17:18 Re: indexing large "text" attributes ... ERROR: maximum size is 8191
Previous Message Benjamin Arai 2007-08-06 02:03:51 indexing large "text" attributes ... ERROR: maximum size is 8191