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