Re: BTree max row size?

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.

In response to

Browse pgsql-general by date

  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