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.
signature.asc
Description: This is a digitally signed message part