(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

Reply via email to