Re: Simple join doesn't use index

From: Ben Chobot <bench(at)silentmedia(dot)com>
To: Alex Vinnik <alvinnik(dot)g(at)gmail(dot)com>
Cc: Filip Rembiałkowski <plk(dot)zuber(at)gmail(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: Simple join doesn't use index
Date: 2013-01-29 17:39:07
Message-ID: 16C72D59-A649-40B1-B5BA-E4875D8DAF7B@silentmedia.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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.

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Alex Vinnik 2013-01-29 18:59:10 Re: Simple join doesn't use index
Previous Message Merlin Moncure 2013-01-29 16:41:47 Re: Simple join doesn't use index