Re: [GENERAL] how to get accurate values in pg_statistic - Mailing list pgsql-performance

From Rod Taylor
Subject Re: [GENERAL] how to get accurate values in pg_statistic
Date
Msg-id 1062721750.89833.10.camel@jester
Whole thread Raw
In response to Re: [GENERAL] how to get accurate values in pg_statistic  (Neil Conway <neilc@samurai.com>)
List 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.

Attachment

pgsql-performance by date:

Previous
From: Mary Edie Meredith
Date:
Subject: Re: [GENERAL] how to get accurate values in pg_statistic
Next
From: "Relaxin"
Date:
Subject: Re: SELECT's take a long time compared to other DBMS