Re: BTree max row size?

Поиск
Список
Период
Сортировка
От Martijn van Oosterhout
Тема Re: BTree max row size?
Дата
Msg-id 20041224231958.GB9866@svana.org
обсуждение исходный текст
Ответ на Re: BTree max row size?  (Ernest Kim <krazykid@cs.bu.edu>)
Список pgsql-general
On Tue, Dec 21, 2004 at 12:51:05PM -0500, Ernest Kim wrote:
>
> I'm trying to use the tiki-wiki software.  It has several indexes
> which store the web page's data as an index criteria.  The problem
> comes up when a web page is a large web page.  It can't store the page
> in the index.
>
> Do you know of another way of dealing with this issue aside from
> re-compiling or recoding the indexes?

I think what he's trying to say is that there is no point sticking the
whole page in an index. It doesn't help for lookup, since you'd need to
know the whole page to use the index. It won't speed LIKE or regular
expressions. The question was basically: why are you trying to put the
whole page in an index since it is apparently useless...
--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
> tool for doing 5% of the work and then sitting around waiting for someone
> else to do the other 95% so you can sue them.

Вложения

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

Предыдущее
От: "Josh Berkus"
Дата:
Сообщение: Re: [sfpug] Basic problem installing TSearch2 (full text
Следующее
От: "Cornelia Boenigk"
Дата:
Сообщение: Merry Christmas