On Sat, 2003-09-20 at 06:14, Jeff wrote: > Well, that depends. First, turn on stats collecting and run "VACUUM > ANALYZE". That will collect some data about your data which helps the > planner make a good choice.
The statistics collector and the statistics collected by ANALYZE have nothing to do with one another -- stats collector stats aren't used by the query planner. So just running ANALYZE or VACUUM ANALYZE should be sufficient. -Neil ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])