Re: Hash Indexes

Поиск
Список
Период
Сортировка
От Jesper Pedersen
Тема Re: Hash Indexes
Дата
Msg-id cae97507-b285-b405-2af6-e2f0199d00d7@redhat.com
обсуждение исходный текст
Ответ на Re: Hash Indexes  (Amit Kapila <amit.kapila16@gmail.com>)
Список pgsql-hackers
On 09/12/2016 10:42 PM, Amit Kapila wrote:
>>> The following script hangs on idx_val creation - just with v5, WAL patch
>>> not applied.
>>
>>
>> Are you sure it is actually hanging? I see 100% cpu for a few minutes but
>> the index eventually completes ok for me (v5 patch applied to today's
>> master).
>>
>
> It completed for me as well.  The second index creation is taking more
> time and cpu, because it is just inserting duplicate values which need
> lot of overflow pages.
>

Yeah, sorry for the false alarm. It just took 3m45s to complete on my 
machine.

Best regards, Jesper




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

Предыдущее
От: Amit Kapila
Дата:
Сообщение: Re: Write Ahead Logging for Hash Indexes
Следующее
От: Robert Haas
Дата:
Сообщение: Re: Hash Indexes