Re: BTree max row size?

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[(at)]dcc(dot)uchile(dot)cl>)
"Las cosas son buenas o malas segun las hace nuestra opinión" (Lisias)