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.