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 1062697606.88158.7.camel@jester
Whole thread Raw
In response to [GENERAL] how to get accurate values in pg_statistic (continued)  (Mary Edie Meredith <maryedie@osdl.org>)
Responses Re: [GENERAL] how to get accurate values in pg_statistic  (Neil Conway <neilc@samurai.com>)
List pgsql-performance
On Thu, 2003-09-04 at 13:41, Mary Edie Meredith wrote:
> Our port of OSDL DBT3 test suite to PostgreSQL (see Background
> information below) is nearing completion.  We would also like to confirm
> our understanding of an outstanding consistency issue.
>
> We have not been able to do meaningful kernel testing since the runs
> (all parameters/kernels being equal) arewildly varying - sometimes
> 20-25% differences in the metrics run to run.

Run a VACUUM FULL ANALYZE between runs.  This will force a full scan of
all data for stats, as well as ensure the table is consistently
compacted.

Attachment

pgsql-performance by date:

Previous
From: William Yu
Date:
Subject: Re: SELECT's take a long time compared to other DBMS
Next
From: Bruce Momjian
Date:
Subject: Re: FreeBSD page size