Re: why postgresql is so slow? - Mailing list pgsql-hackers

From Neil Conway
Subject Re: why postgresql is so slow?
Date
Msg-id 1064072064.4630.353.camel@tokyo
Whole thread Raw
In response to Re: why postgresql is so slow?  (Jeff <jdavis-pgsql@empires.org>)
List pgsql-hackers
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




pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: 7.4beta2 vs 7.3.3
Next
From: Carlos Guzman Alvarez
Date:
Subject: Re: Array Parameters on protocol 3.0