From: | Martijn van Oosterhout <kleptog(at)svana(dot)org> |
---|---|
To: | Ernest Kim <krazykid(at)cs(dot)bu(dot)edu> |
Cc: | Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: BTree max row size? |
Date: | 2004-12-24 23:20:07 |
Message-ID: | 20041224231958.GB9866@svana.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(at)svana(dot)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.
From | Date | Subject | |
---|---|---|---|
Next Message | Cornelia Boenigk | 2004-12-25 12:32:43 | Merry Christmas |
Previous Message | Josh Berkus | 2004-12-24 21:24:59 | Re: [sfpug] Basic problem installing TSearch2 (full text |