"Ross J. Reedstrom" wrote:
> 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.
Yes, the tables were VACUUM ANALYZE'd.
Regards,
Thomas.