Skip site navigation (1) Skip section navigation (2)

Re: BTree max row size?

From: Ernest Kim <krazykid(at)cs(dot)bu(dot)edu>
To: Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: BTree max row size?
Date: 2004-12-21 17:51:05
Message-ID: 20041221175105.GD13008@cs.bu.edu (view raw or flat)
Thread:
Lists: pgsql-general
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[(at)]dcc(dot)uchile(dot)cl>)
> "Las cosas son buenas o malas segun las hace nuestra opiniĆ³n" (Lisias)

In response to

Responses

pgsql-general by date

Next:From: Frank D. Engel, Jr.Date: 2004-12-21 19:04:02
Subject: Re: Need help to organize database
Previous:From: Tom LaneDate: 2004-12-21 15:54:27
Subject: Re: DELETE versus TRUNCATE during pg_dump....

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group