Re: gsoc, oprrest function for text search take 2
От | Alvaro Herrera |
---|---|
Тема | Re: gsoc, oprrest function for text search take 2 |
Дата | |
Msg-id | 20080814213304.GI4232@alvh.no-ip.org обсуждение исходный текст |
Ответ на | Re: gsoc, oprrest function for text search take 2 (Jan Urbański <j.urbanski@students.mimuw.edu.pl>) |
Ответы |
Re: gsoc, oprrest function for text search take 2
|
Список | pgsql-hackers |
Jan Urbański wrote: > Heikki Linnakangas wrote: >> Sounds like a plan. In (2), it's even better to detoast the values >> lazily. For a typical one-word tsquery, the binary search will only >> look at a small portion of the elements. > > Hm, how can I do that? Toast is still a bit black magic to me... Do you > mean I should stick to having Datums in TextFreq? Store both the Datum and the text *. If the latter is NULL, then grab the datum, detoast and store the result in the text *. Next time you need to look at it, it's already detoasted. I don't know the code so I have no idea if this is applicable. -- Alvaro Herrera http://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc.
В списке pgsql-hackers по дате отправления: