Re: 7.0.2 and 6.5.3 performance

From: "Ross J(dot) Reedstrom" <reedstrm(at)rice(dot)edu>
To: lec <englim(at)pc(dot)jaring(dot)my>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: 7.0.2 and 6.5.3 performance
Date: 2000-09-17 03:45:34
Message-ID: 20000916224534.A31390@rice.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(at)rice(dot)edu>
NSBRI Research Scientist/Programmer
Computer and Information Technology Institute
Rice University, 6100 S. Main St., Houston, TX 77005

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Horst Herb 2000-09-17 04:01:05 inheritance problem
Previous Message Joel Burton 2000-09-16 22:47:35 All function parameters become NULL if one is?