(Not sure how we'd implement that, seeing that ANALYZE currently works on one table at a time, but it's probably doable --- and it'd fix the fundamental problem for correlation statistics, which is how not to try to collect stats about an exponential number of combinations ...)
An exponential number of combinations? Is it possible to use FK relationships to determine what tables & columns are likely to be used in future joins.
Josh ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
