Re: [SQL] index row size 2728 exceeds btree maximum, 2713

"Ramakrishnan Muralidharan" <ramakrishnanm@xxxxxxxxxxxxxxxxxxxxxx> · Thu, 2 Jun 2005 16:43:33 +0530

         Hi 

It is not advisable to add a variable length data field in the Index key, since 
it is very difficult predict the size of the field which may vary from record to 
record.  

are you included this field for Full text search on data 
field?

Regards,
R.Muralidharan

  -----Original Message-----
From: 
  pgsql-sql-owner@xxxxxxxxxxxxxx [mailto:pgsql-sql-owner@xxxxxxxxxxxxxx]On 
  Behalf Of Dinesh Pandey
Sent: Thursday, January 01, 2004 3:14 
  PM
To: Ramakrishnan Muralidharan; pgsql-general@xxxxxxxxxxxxxx; 
  'PostgreSQL'
Subject: Re: [SQL] index row size 2728 exceeds btree 
  maximum, 2713

  Hi,

  One of the columns 
  in primary key is of type “TEXT”. I am able to insert with small data, but for 
  around 3000 characters it’s failing. How to handle 
  that?

  Thanks
Dinesh 
  Pandey

  From: 
  Ramakrishnan Muralidharan [mailto:ramakrishnanm@xxxxxxxxxxxxxxxxxxxxxx] 

Sent: Thursday, June 02, 
  2005 3:11 PM
To: 
  dpandey@xxxxxxxx; 
  pgsql-general@xxxxxxxxxxxxxx; PostgreSQL
Subject: RE: [SQL] index row size 2728 
  exceeds btree maximum, 2713

  Hi,

  The issue looks like your Index width exceeds the maximum width 
   of the index key 
  limit, Please review the keys used in the index.

  Regards,

  R.Muralidharan

    -----Original 
    Message-----
From: 
    pgsql-sql-owner@xxxxxxxxxxxxxx 
    [mailto:pgsql-sql-owner@xxxxxxxxxxxxxx]On Behalf Of Dinesh Pandey
Sent: Thursday, June 02, 2005 12:35 
    PM
To: 
    pgsql-general@xxxxxxxxxxxxxx; 'PostgreSQL'
Subject: [SQL] index row size 2728 
    exceeds btree maximum, 2713
    TABLE 

    -----------+-----------------------+-----------
      Column   
     |         
    Type       
    -----------+-----------------------+-----------
     scan_id   
     | 
    bigint                

     host_ip   
     | character varying(15) 
     port_num | 
    integer               

     plugin_id  | 
    integer  

     severity   | 
    character varying(50) 
     data      
     | text                  

    Indexes:

    "pk_scanned_port_info" PRIMARY KEY, btree (scan_id, host_ip, port_num, 
    plugin_id, severity, data)

    On 
    inserting record I am getting this error “index 
    row size 2728 exceeds btree maximum, 2713”

    How 
    to solve this problem?