Re: Reallife szenario for GEQO

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Bernd Helmle <mailings(at)oopsware(dot)de>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Reallife szenario for GEQO
Date: 2004-01-13 15:06:15
Message-ID: 11287.1074006375@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Bernd Helmle <mailings(at)oopsware(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jeff Eckermann 2004-01-13 15:08:18 Re: Any real known bugs about wrong selects?
Previous Message Robert Treat 2004-01-13 14:48:01 Re: insertion with trigger failed unexpectedly