Postgres Pro
Downloads
Home   >   mailing lists

Re: Simple join doesn't use index - Mailing list pgsql-performance

From Ben Chobot
Subject Re: Simple join doesn't use index
Date
Msg-id 16C72D59-A649-40B1-B5BA-E4875D8DAF7B@silentmedia.com
Whole thread Raw
In response to Re: Simple join doesn't use index  (Alex Vinnik <alvinnik.g@gmail.com>)
Responses Re: Simple join doesn't use index  (Alex Vinnik <alvinnik.g@gmail.com>)
List pgsql-performance
Tree view
On Jan 29, 2013, at 6:24 AM, Alex Vinnik wrote:

random_page_cost=1 might be not what you really want. 
it would mean that random reads are as fast as as sequential reads, which probably is true only for SSD
What randon_page_cost would be more appropriate for EC2 EBS Provisioned volume that can handle 2,000 IOPS? 

For EC2 Provisioned IOPS volumes - not standard EBS - random_page_cost=1 is exactly what you want.

pgsql-performance by date:

Previous
From: Merlin Moncure
Date:
Subject: Re: Simple join doesn't use index
Next
From: Alex Vinnik
Date:
Subject: Re: Simple join doesn't use index