Re: Fixing GIN for empty/null/full-scan cases

Поиск
Список
Период
Сортировка
От David E. Wheeler
Тема Re: Fixing GIN for empty/null/full-scan cases
Дата
Msg-id 9D548B31-7C3B-4D92-B591-80A1FBE5B657@kineticode.com
обсуждение исходный текст
Ответ на Re: Fixing GIN for empty/null/full-scan cases  (Josh Berkus <josh@agliodbs.com>)
Ответы Re: Fixing GIN for empty/null/full-scan cases  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
On Jan 4, 2011, at 3:18 PM, Josh Berkus wrote:

> Actually, there's been a *lot* of complaining about the GIN issues.
> It's just that most of that complaining doesn't reach -hackers.
>
> The common pattern I've seen in our practice and on IRC is:
>
> 1) user has GiST indexes
> 2) user tries converting them to GIN
> 3) user gets "full index scan" errors
> 4) user switches back and gives up

We (PGX) actually have a client who could use this. Tom, if you have patches as you work on this (or, better, a branch
ina Git repo), I could do some testing on your client's code with it. It would involve converting from a GiST to a GIN
indexand then seeing how well the queries fare. Would that be helpful to you? 

Best,

David



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

Предыдущее
От: Florian Pflug
Дата:
Сообщение: Re: LOCK for non-tables
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Fixing GIN for empty/null/full-scan cases