Postgres Pro
Downloads
Home   >   mailing lists

Re: Index Scans become Seq Scans after VACUUM ANALYSE - Mailing list pgsql-hackers

From Luis Alberto Amigo Navarro
Subject Re: Index Scans become Seq Scans after VACUUM ANALYSE
Date
Msg-id 00b901c1e6a8$f8e66ef0$cab990c1@atc.unican.es
Whole thread Raw
In response to Re: Index Scans become Seq Scans after VACUUM ANALYSE  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-hackers
Tree view 
>
> 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

pgsql-hackers by date:

Previous
From: "Christopher Kings-Lynne"
Date:
Subject: Oops!
Next
From: Andreas Scherbaum
Date:
Subject: Re: new food for the contrib/ directory