Re: 7.0.2 and 6.5.3 performance

From: lec <englim(at)pc(dot)jaring(dot)my>
To: "Ross J(dot) Reedstrom" <reedstrm(at)rice(dot)edu>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: 7.0.2 and 6.5.3 performance
Date: 2000-09-18 01:48:49
Message-ID: 39C57480.980C3987@pc.jaring.my
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2000-09-18 02:03:20 Re: Large Objects Across a Network
Previous Message felix 2000-09-18 01:14:59 Re: LOCK TABLE