Re: [PERFORM] planner costs in "warm cache" tests

2010-05-31 Thread Tom Lane
Jesper Krogh writes: > On 2010-05-30 20:34, Tom Lane wrote: >> Well, hmm, I really doubt that that represents reality either. A page >> access is by no means "free" even when the page is already in cache. >> I don't recall anyone suggesting that you set these numbers to less >> than perhaps 0.01.

Re: [PERFORM] planner costs in "warm cache" tests

2010-05-31 Thread Jesper Krogh
On 2010-05-30 20:34, Tom Lane wrote: Jesper Krogh writes: testdb=# set seq_page_cost = 0.1; SET testdb=# set random_page_cost = 0.1; SET Well, hmm, I really doubt that that represents reality either. A page access is by no means "free" even when the page is already in cache.

Re: [PERFORM] Zeus IOPS

2010-05-31 Thread Scott Marlowe
On Mon, May 31, 2010 at 7:06 AM, Brad Nicholson wrote: > On Fri, 2010-05-28 at 13:48 -0600, Scott Marlowe wrote: >> Anybody on the list have any experience with these drives?  They get >> good numbers but I can't find diddly on them on the internet for the >> last year or so. >> >> http://www.stec

Re: [PERFORM] Zeus IOPS

2010-05-31 Thread Brad Nicholson
On Fri, 2010-05-28 at 13:48 -0600, Scott Marlowe wrote: > Anybody on the list have any experience with these drives? They get > good numbers but I can't find diddly on them on the internet for the > last year or so. > > http://www.stec-inc.com/product/zeusiops.php I'd heard that they were a popu