Postgres Pro
Downloads
Home   >   mailing lists

Re: index item size 4496 exceeds maximum 2713 - Mailing list pgsql-admin

From Tom Lane
Subject Re: index item size 4496 exceeds maximum 2713
Date
Msg-id 13509.1015310470@sss.pgh.pa.us
Whole thread Raw
In response to index item size 4496 exceeds maximum 2713  (Jon Hassen <jhassen@azstarnet.com>)
List pgsql-admin
Tree view 
Jon Hassen <jhassen@azstarnet.com> writes:
>   When I try and create an index on a text field, I get this response:
> "ERROR:  btree: index item size 4496 exceeds maximum 2713"
>   On another PGSQL database I only got that message when the size was above
> 8192.

Perhaps you were using BLCKSZ=32K on the other system?

            regards, tom lane

pgsql-admin by date:

Previous
From: Eric Scroger
Date:
Subject: Re: SEMMNI,SEMMNS config for posgres 7.1 under Solaris
Next
From: "Gaetano Mendola"
Date:
Subject: Re: postmaster problem....