Review: HStore Gin Speedup

Поиск
Список
Период
Сортировка
От Antonin Houska
Тема Review: HStore Gin Speedup
Дата
Msg-id 528A9BC9.3020202@gmail.com
обсуждение исходный текст
Список pgsql-hackers
Following are my initial comments for
https://commitfest.postgresql.org/action/patch_view?id=1203


1. It no longer applies, probably due to commit
a18167510f4c385329697588ce5132cbf95779c3

error: contrib/hstore/hstore--1.1.sql: No such file or directory


2. Compatibility with HStore v2.0
(https://commitfest.postgresql.org/action/patch_view?id=1289)

As long as the separate operator class gin_hstore_combined_ops is used,
there should be no conflict. I'll verify as soon as the $subject patch
is applicable to master.


3. Regression tests

Shouldn't EXPLAIN be there too? I suggest a test that creates 2 indexes
on the hstore column - one using the existing GIN (default) opclass and
one using the new one (combined). The execution plan will then show if
an index is used and if it's the correct one.


// Antonin Houska (Tony)



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

Предыдущее
От: Christophe Pettus
Дата:
Сообщение: Re: Data corruption issues using streaming replication on 9.0.14/9.2.5/9.3.1
Следующее
От: Jim Mlodgenski
Дата:
Сообщение: Re: Custom Scan APIs (Re: Custom Plan node)