Philip Greer <[EMAIL PROTECTED]> writes:
> WTF? Why would a vacuum be necessary in order for it to start using the index?
It's not the VACUUM that's necessary; it's the ANALYZE. The query
planner uses table statistics to make its decisions, and ANALYZE is
what collects those statistics. Without an ANALYZE the planner will
make default assumptions that are rarely correct. :)
VACUUM should also be run regularly, of course.
-Doug
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
