Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: index item size 4496 exceeds maximum 2713
Date
Msg-id 23041.1015431263@sss.pgh.pa.us
Whole thread Raw
In response to Re: index item size 4496 exceeds maximum 2713  (ghaverla@freenet.edmonton.ab.ca)
List pgsql-novice
Tree view 
ghaverla@freenet.edmonton.ab.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

pgsql-novice by date:

Previous
From: ghaverla@freenet.edmonton.ab.ca
Date:
Subject: Re: index item size 4496 exceeds maximum 2713
Next
From: Ugly Hippo
Date:
Subject: pg equivalent to MS SQL exec command