Re: Simple join doesn't use index

Поиск
Список
Период
Сортировка
От Ben Chobot
Тема Re: Simple join doesn't use index
Дата
Msg-id 16C72D59-A649-40B1-B5BA-E4875D8DAF7B@silentmedia.com
обсуждение исходный текст
Ответ на Re: Simple join doesn't use index  (Alex Vinnik <alvinnik.g@gmail.com>)
Ответы Re: Simple join doesn't use index  (Alex Vinnik <alvinnik.g@gmail.com>)
Список 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.

В списке pgsql-performance по дате отправления:

Предыдущее
От: Merlin Moncure
Дата:
Сообщение: Re: Simple join doesn't use index
Следующее
От: Alex Vinnik
Дата:
Сообщение: Re: Simple join doesn't use index