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 (<[EMAIL PROTECTED]>) > "Las cosas son buenas o malas segun las hace nuestra opinión" (Lisias) ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
