Re: Index Scans become Seq Scans after VACUUM ANALYSE

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Michael Loftis <mloftis(at)wgops(dot)com>
Cc: Mark Pritchard <mark(at)tangent(dot)net(dot)au>, Luis Alberto Amigo Navarro <lamigo(at)atc(dot)unican(dot)es>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Index Scans become Seq Scans after VACUUM ANALYSE
Date: 2002-04-18 14:56:43
Message-ID: 12133.1019141803@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Michael Loftis <mloftis(at)wgops(dot)com> writes:
> Somethings wrong with the random numbers from the sun... re-run them,
> that first sample is insane.... Caching looks like it's affecctign your
> results alot...

Yeah; it looks like the test case is not large enough to swamp out
caching effects on the Sun box. It is on the Linux box, evidently,
since the 10:1 ratio appears very repeatable.

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Alexandre Dulaunoy 2002-04-18 15:02:43 Re: new food for the contrib/ directory
Previous Message Tom Lane 2002-04-18 14:52:40 Re: timeout implementation issues