Re: gist index build produces corrupt result on first access

Поиск
Список
Период
Сортировка
От Teodor Sigaev
Тема Re: gist index build produces corrupt result on first access
Дата
Msg-id 40472A69.1060308@sigaev.ru
обсуждение исходный текст
Ответ на Re: gist index build produces corrupt result on first access to table.  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general

Tom Lane wrote:
> Eric Davies <eric@barrodale.com> writes:
>
>>We've looked at the contrib/cube code, but it's also a variable length
>>parameter, and it uses a very different parameter passing mechanism.
>
>
> Different how?  I have a hard-to-pin-down intuition that your problem is
> closely associated with this issue, but without details it's impossible
> to say more.  IIRC there were once assumptions in rtree and/or gist
> about the indexable datatype being pass-by-ref and/or varlena, and I'm
> not sure how much of that has been fixed.
contribs rtree_gist, btree_gist and seg uses pass-by-ref fixed length value for
storage, and there isn't such problem.


It seems to me, the problem may be in union or picksplit methods, but I needs
more info.

I advice to play with gevel module (
http://www.sai.msu.su/~megera/postgres/gist/gevel/README.gevel,
http://www.sai.msu.su/~megera/postgres/gist/gevel/gevel.tar.gz
)



--
Teodor Sigaev                                  E-mail: teodor@sigaev.ru

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

Предыдущее
От: Mihai RUSU
Дата:
Сообщение: Re: libpq API for PQcmdTuples()
Следующее
От: Richard Huxton
Дата:
Сообщение: Re: Are Postgres 7.4.1 RPMs available for SuSE 9.0 ?