I got bit by that darn GEQO setting again... - Mailing list pgsql-general

From Mike Mascari
Subject I got bit by that darn GEQO setting again...
Date
Msg-id 4008C8D7.2030000@mascari.com
Whole thread Raw
Responses Re: I got bit by that darn GEQO setting again...  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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



pgsql-general by date:

Previous
From: David Garamond
Date:
Subject: Re: embedded/"serverless" (Re: serverless postgresql)
Next
From:
Date:
Subject: 7.4 -> 7.4.1 upgrade with customization on freebsd