Josh Berkus <[EMAIL PROTECTED]> writes: > I am very strongly in favor of this idea. I would personally prefer it if > the Join collapsing parmeter could be set at query time through a SET > statement, but will of course defer to the difficulty level in doing so.
I guess I failed to make it clear that that's what I meant. GUC variables are those things that you can set via SET, or in the postgresql.conf file, etc. These values would be just as manipulable as, say, ENABLE_SEQSCAN. > How about: > EXPLICIT_JOIN_MINIMUM > and > FROM_COLLAPSE_LIMIT > Just to make the two params not sound so identical? Hmm. The two parameters would have closely related functions, so I'd sort of think that the names *should* be pretty similar. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html