Re: index item size 4496 exceeds maximum 2713

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: ghaverla(at)freenet(dot)edmonton(dot)ab(dot)ca
Cc: Andrew McMillan <andrew(at)catalyst(dot)net(dot)nz>, pgsql-novice(at)postgresql(dot)org
Subject: Re: index item size 4496 exceeds maximum 2713
Date: 2002-03-06 16:14:23
Message-ID: 23041.1015431263@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

ghaverla(at)freenet(dot)edmonton(dot)ab(dot)ca writes:
> Where does this number of 3 come from?

The btree code breaks if it's not able to put at least three index
entries on a page.

regards, tom lane

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Ugly Hippo 2002-03-06 16:36:29 pg equivalent to MS SQL exec command
Previous Message ghaverla 2002-03-06 10:13:19 Re: index item size 4496 exceeds maximum 2713