Horton

Re: Index Scans become Seq Scans after VACUUM ANALYSE

Bruce Momjian <pgman@candle.pha.pa.us>

View thread View on postgr.es
From: Bruce Momjian <pgman@candle.pha.pa.us>
To: Michael Loftis <mloftis@wgops.com>
Cc: pgsql-hackers@postgresql.org
Date: 2002-04-17T21:41:43Z
Lists: pgsql-hackers 
Michael Loftis wrote:
> As far as the 'planner benchmark suite' so we cans tart gathering more 
> statistical data about what costs should be, or are better at, that's an 
> excellent idea.

People with different hardware have different random page costs,
clearly.  Even different workloads affect it.  Added to TODO:

	* Add utility to compute accurate random_page_cost value

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026