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?
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:
> > 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
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 Lane||Date: 2004-12-21 15:54:27|
|Subject: Re: DELETE versus TRUNCATE during pg_dump.... |