Re: why postgresql is so slow?

From: Neil Conway <neilc(at)samurai(dot)com>
To: Jeff <jdavis-pgsql(at)empires(dot)org>
Cc: PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: why postgresql is so slow?
Date: 2003-09-20 15:34:24
Message-ID: 1064072064.4630.353.camel@tokyo
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2003-09-20 15:37:32 Re: pgsql-server/src/backend catalog/index.c comma ...
Previous Message Tom Lane 2003-09-20 15:12:32 Re: 7.4beta2 vs 7.3.3