Postgres Pro
Downloads
Home   >   mailing lists

Re: [SQL] index row size 2728 exceeds btree maximum, 2713 - Mailing list pgsql-general

From Ramakrishnan Muralidharan
Subject Re: [SQL] index row size 2728 exceeds btree maximum, 2713
Date
Msg-id 02767D4600E59A4487233B23AEF5C5992A408F@blrmail1.aus.pervasive.com
Whole thread Raw
Responses Re: [SQL] index row size 2728 exceeds btree maximum, 2713
List pgsql-general
Tree view
         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@postgresql.org [mailto:pgsql-sql-owner@postgresql.org]On Behalf Of Dinesh Pandey
Sent: Thursday, June 02, 2005 12:35 PM
To: pgsql-general@postgresql.org; '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?

 

 

 

pgsql-general by date:

Previous
From: Himanshu Baweja
Date:
Subject: Stats not getting updated....
Next
From: Kaloyan Iliev Iliev
Date:
Subject: Re: One Sequence for all tables or one Sequence for each