Re: BRIN INDEX value

Поиск
Список
Период
Сортировка
От Tatsuo Ishii
Тема Re: BRIN INDEX value
Дата
Msg-id 20150904.175332.2161241032515084861.t-ishii@sraoss.co.jp
обсуждение исходный текст
Ответ на Re: BRIN INDEX value  (Amit Kapila <amit.kapila16@gmail.com>)
Список pgsql-hackers
> On Fri, Sep 4, 2015 at 10:03 AM, Tatsuo Ishii <ishii@postgresql.org> wrote:
>>
>> I have looked into your patch and am a little bit worried because it
>> calls RelationGetNumberOfBlocks() which is an expensive function.
>> I think there are two ways to avoid it.
>>
>> 1) fall back to your former patch. However it may break existing
>>    behavior what you said. I think there's very little chance it
>>    actually happens because IndexBuildHeapRangeScan() is only used by
>>    brin (I confirmed this). But Alvaro said some patches may be it's
>>    customers. Robert, Amit, Can you please confirm this?
>>
> 
> In earlier version of parallel_seqscan patch, heap_setscanlimits() was being
> used, but now altogether a different mechanism is used.

Thank you for the confirmation!

Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp



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

Предыдущее
От: Fujii Masao
Дата:
Сообщение: gin_fuzzy_search_limit and postgresql.conf.sample
Следующее
От: Simon Riggs
Дата:
Сообщение: Re: Declarative partitioning