Horton

Re: Index Scans become Seq Scans after VACUUM ANALYSE

Tom Lane <tgl@sss.pgh.pa.us>

View thread View on postgr.es
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Michael Loftis <mloftis@wgops.com>
Cc: Mark Pritchard <mark@tangent.net.au>, Luis Alberto Amigo Navarro <lamigo@atc.unican.es>, pgsql-hackers@postgresql.org
Date: 2002-04-18T14:56:43Z
Lists: pgsql-hackers 
Michael Loftis <mloftis@wgops.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