Postgres Pro
Downloads
Home   >   mailing lists

Re: PG for DataWarehouse type Queries - Mailing list pgsql-general

From Tom Lane
Subject Re: PG for DataWarehouse type Queries
Date
Msg-id 8581.1186366212@sss.pgh.pa.us
Whole thread Raw
In response to Re: PG for DataWarehouse type Queries  (Ow Mun Heng <Ow.Mun.Heng@wdc.com>)
List pgsql-general
Tree view 
Ow Mun Heng <Ow.Mun.Heng@wdc.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

pgsql-general by date:

Previous
From: Benjamin Arai
Date:
Subject: indexing large "text" attributes ... ERROR: maximum size is 8191
Next
From: Tom Lane
Date:
Subject: Re: indexing large "text" attributes ... ERROR: maximum size is 8191