Re: Strange issue with GiST index scan taking far too long

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Strange issue with GiST index scan taking far too long
Дата
Msg-id 21579.1213032314@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Strange issue with GiST index scan taking far too long  (Simon Riggs <simon@2ndquadrant.com>)
Ответы Re: Strange issue with GiST index scan taking far too long
Список pgsql-hackers
Simon Riggs <simon@2ndquadrant.com> writes:
> On Mon, 2008-06-09 at 11:49 -0400, Tom Lane wrote:
>> Is the value you are fetching from the geography table large enough to
>> be toasted?  I'm thinking you might be looking at the cost of repeated
>> de-toastings.

> So you are saying it is de-toasted 32880 times, in this case? If not,
> where are the repeated de-toastings happening?

Inside the index support functions.  I'm thinking we could fix this by
forcibly detoasting values passed as index scan keys, but it's not quite
clear where's the best place to do that.
        regards, tom lane


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

Предыдущее
От: Andrew Dunstan
Дата:
Сообщение: Re: proposal: new contrib module - session variables
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Proposal: GiST constraints