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

Attachment: signature.asc
Description: This is a digitally signed message part

Reply via email to