On Sat, Sep 16, 2000 at 12:42:30PM +0800, lec wrote:
> Tom Lane wrote:
> >
> > Um, have you vacuum analyzed the tables involved?
>
> The tables were vacuumed before explain.
>
Just to clairify: 'VACUUM'ed, or 'VACUUM ANALYZE'd? There's a
difference. A plain vacuum just reclaims space, the ANALYZE keyword is
needed to update the stats.
--
Ross J. Reedstrom, Ph.D., <reedstrm@rice.edu>
NSBRI Research Scientist/Programmer
Computer and Information Technology Institute
Rice University, 6100 S. Main St., Houston, TX 77005