Re: BTree max row size?

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?

-Ernie

On Sat, Dec 18, 2004 at 12:20:29PM -0300, Alvaro Herrera wrote:
> On Thu, Dec 16, 2004 at 06:20:57PM -0500, Ernest Kim wrote:
>
> Hi,
>
> > I'm getting the following error message when I try to update a row in
> > a table:
> >
> > ERROR:  54000: index row size 2720 exceeds btree maximum, 2713
> >
> > Does anyone know how to to change the btree maximum row size?  How did
> > it come up with 2713 as a max row size?
>
> You could compile Postgres with BLCKSZ set to a higher value (currently
> 8192).  Or you could change your indexing strategy, because if you now
> want to store 2720 bytes, some other day you may want to store 11000,
> and then you would overflow the ~10900 bytes that a 32768 BLCKSZ would
> buy you.
>
> What are you indexing?
>
> The 2713 comes from (8192 - some overhead) / 3.
>
> --
> Alvaro Herrera (<alvherre[@]dcc.uchile.cl>)
> "Las cosas son buenas o malas segun las hace nuestra opinión" (Lisias)