I got bit by that darn GEQO setting again...

From: Mike Mascari <mascarm(at)mascari(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: I got bit by that darn GEQO setting again...
Date: 2004-01-17 05:32:07
Message-ID: 4008C8D7.2030000@mascari.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I know Tom would like a definitive and thorough testing to determine the
proper GEQO threshold limit , and that is the right thing to do, of course.

But just as a quick notice to those upgrading from 7.3 to 7.4 with fully
normalized databases requiring > 11 joins, the GEQO setting can be a
killer...

How about a TIP:

"For large number of joins, test whether the GEQO settings are right for
you"

Mike Mascari

Responses

Browse pgsql-general by date

  From Date Subject
Next Message bill.postgresql-users 2004-01-17 05:32:45 7.4 -> 7.4.1 upgrade with customization on freebsd
Previous Message David Garamond 2004-01-17 05:11:43 Re: embedded/"serverless" (Re: serverless postgresql)