Re: Reallife szenario for GEQO - Mailing list pgsql-general

From Bernd Helmle
Subject Re: Reallife szenario for GEQO
Date
Msg-id 4004272A.6050309@oopsware.de
Whole thread Raw
In response to Re: Reallife szenario for GEQO  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tom Lane wrote:
> Bernd Helmle <mailings@oopsware.de> writes:
>
>>But what means "enough tables"?
>
>
> GEQO_THRESHOLD or more.  You can set that anywhere you like (I think the
> default is 11 or 12, which is about where the standard exhaustive-search
> planner becomes painfully slow).
>
>             regards, tom lane
>

Thank you Tom, that's helpful.

   Bernd



pgsql-general by date:

Previous
From: "Marc G. Fournier"
Date:
Subject: Re: Postgress and MYSQL
Next
From: "Keith G. Murphy"
Date:
Subject: Re: Best practice? Web application: single PostgreSQL