random_page_cost vs ssd? - Mailing list pgsql-performance

From Jeff
Subject random_page_cost vs ssd?
Date
Msg-id B1349331-0035-4FFE-80E9-91A4B168F4DB@torgo.978.org
Whole thread Raw
Responses Re: random_page_cost vs ssd?
List pgsql-performance
I've got a couple x25-e's in production now and they are working like
a champ.  (In fact, I've got another box being built with all x25s in
it. its going to smoke!)

Anyway, I was just reading another thread on here and that made me
wonder about random_page_cost in the world of an ssd where a seek is
basically free.  I haven't tested this yet (I can do that next week),
but logically, in this scenario wouldn't lowering random_page_cost be
ideal or would it not really matter in the grand scheme of things?

--
Jeff Trout <jeff@jefftrout.com>
http://www.stuarthamm.net/
http://www.dellsmartexitin.com/




pgsql-performance by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: Query performance over a large proportion of data
Next
From: Grzegorz Jaśkiewicz
Date:
Subject: Re: random_page_cost vs ssd?