Horton

Re: Index Scans become Seq Scans after VACUUM ANALYSE

Luis Alberto Amigo Navarro <lamigo@atc.unican.es>

View thread View on postgr.es
From: "Luis Alberto Amigo Navarro" <lamigo@atc.unican.es>
To: "mlw" <markw@mohawksoft.com>, "Andrew Sullivan" <andrew@libertyrms.info>
Cc: <pgsql-hackers@postgresql.org>, "Tom Lane" <tgl@sss.pgh.pa.us>
Date: 2002-04-18T07:16:34Z
Lists: pgsql-hackers 
>
> Look at the pgbench utility. I can't run that program without a +- 10%
> variation from run to run, no mater how many times I run vacuum and
checkpoint.
>

It's pgbench's fault, TPC-B was replaced with TPC-C because it is not
accurate enough, we run a pseudo TPC-H and it has almost no variations from
one run to another.

Regards