Gregory Stark <[EMAIL PROTECTED]> writes: > The SearchCatCache here is the one in get_attavgwidth called to estimate the > relation width.
Hmm, that information is supposed to be cached ... could you provide the test case? > The first thing that comes to mind is that we're doing the > constraint_exclusion code *after* estimating the width of the relations we're > going to exclude. If we push the constraint exclusion up a few lines the > planning time goes down the 1.7s. ... and probably breaks a few things; are you sure there are no needed side effects of the skipped code? regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings