Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: Index Scans become Seq Scans after VACUUM ANALYSE
Date
Msg-id 12133.1019141803@sss.pgh.pa.us
Whole thread Raw
In response to Re: Index Scans become Seq Scans after VACUUM ANALYSE  (Michael Loftis <mloftis@wgops.com>)
Responses Re: Index Scans become Seq Scans after VACUUM ANALYSE  (Mark Pritchard <mark@tangent.net.au>)
List pgsql-hackers
Tree view 
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

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: timeout implementation issues
Next
From: Alexandre Dulaunoy
Date:
Subject: Re: new food for the contrib/ directory