Re: Index Scans become Seq Scans after VACUUM ANALYSE

From: "Luis Alberto Amigo Navarro" <lamigo(at)atc(dot)unican(dot)es>
To: "mlw" <markw(at)mohawksoft(dot)com>, "Andrew Sullivan" <andrew(at)libertyrms(dot)info>
Cc: <pgsql-hackers(at)postgresql(dot)org>, "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Subject: Re: Index Scans become Seq Scans after VACUUM ANALYSE
Date: 2002-04-18 07:16:34
Message-ID: 00b901c1e6a8$f8e66ef0$cab990c1@atc.unican.es
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Maarten.Boekhold 2002-04-18 07:17:34 Re: Index Scans become Seq Scans after VACUUM ANALYSE
Previous Message Nicolas Bazin 2002-04-18 07:13:24 Re: [HACKERS] build of 7.2.1 on SCO Openserver and Unixware