Re: Yet another fast GiST build

Поиск
Список
Период
Сортировка
От Pavel Borisov
Тема Re: Yet another fast GiST build
Дата
Msg-id CALT9ZEGQG5JqqaYtS1UKSKGgiBEo9W9ox5e62c2rmPbEiJzrpQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Yet another fast GiST build  (Andrey Borodin <x4mmm@yandex-team.ru>)
Список pgsql-hackers

>> +    return (ia->lower > ib->lower) ? 1 : -1;
>> +}
>
> We're only dealing with leaf items during index build, so the 'upper' and 'lower' should always be equal here, right? Maybe add a comment and an assertion on that.
>
> (It's pretty sad that the on-disk representation is identical for leaf and internal items, because that wastes a lot of disk space, but that's way out of scope for this patch.)

Thanks, I've added assert() where is was easy to test equalty.

PFA patch with all types.

I had a plan to implement and test one type each day. I did not quite understood how rich our type system is.

Cool, thanks!

BTW there is a somewhat parallel discussion on this gist patch in pgsql-bugs which you may miss 

The main point is that buffering build is better to be enforced with buffering=on as otherwise buffering build becomes hard to test in the presence of sort support.
 
--
Best regards,
Pavel Borisov

Postgres Professional: http://postgrespro.com

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

Предыдущее
От: Rémi Lapeyre
Дата:
Сообщение: Re: Add header support to text format and matching feature
Следующее
От: Andres Freund
Дата:
Сообщение: Re: dynamic result sets support in extended query protocol