Re: index item size 4496 exceeds maximum 2713

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Jon Hassen <jhassen(at)azstarnet(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: index item size 4496 exceeds maximum 2713
Date: 2002-03-05 06:41:10
Message-ID: 13509.1015310470@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Jon Hassen <jhassen(at)azstarnet(dot)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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Meaghan 2002-03-05 07:02:51 Postgresql 7.1 "No database files found"
Previous Message Sean Chittenden 2002-03-05 04:16:42 Re: [ADMIN] password change...