Re: [GENERAL] how to get accurate values in pg_statistic

From: Rod Taylor <rbt(at)rbt(dot)ca>
To: Neil Conway <neilc(at)samurai(dot)com>
Cc: Mary Edie Meredith <maryedie(at)osdl(dot)org>, pgsql-performance <pgsql-performance(at)postgresql(dot)org>, OSDL - DB General <osdldbt-general(at)lists(dot)sourceforge(dot)net>
Subject: Re: [GENERAL] how to get accurate values in pg_statistic
Date: 2003-09-05 00:29:11
Message-ID: 1062721750.89833.10.camel@jester
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Thu, 2003-09-04 at 19:50, Neil Conway wrote:
> On Thu, 2003-09-04 at 13:46, Rod Taylor wrote:
> > Run a VACUUM FULL ANALYZE between runs. This will force a full scan of
> > all data for stats
>
> It will? Are you sure about that?

You're right. According to the docs it won't.

I had a poor stats issue on one table that was solved using that
command, coincidentally apparently.

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Relaxin 2003-09-05 00:45:20 Re: SELECT's take a long time compared to other DBMS
Previous Message Mary Edie Meredith 2003-09-05 00:01:56 Re: [GENERAL] how to get accurate values in pg_statistic