| From: | Richard Huxton <dev(at)archonet(dot)com> |
|---|---|
| To: | dpandey(at)secf(dot)com |
| Cc: | pgsql-general(at)postgresql(dot)org, 'PostgreSQL' <pgsql-sql(at)postgresql(dot)org> |
| Subject: | Re: [SQL] index row size 2728 exceeds btree maximum, 2713 |
| Date: | 2005-06-02 10:43:45 |
| Message-ID: | 429EE2E1.30904@archonet.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-sql |
Dinesh Pandey wrote:
> I am inserting some log messages in the column "data". (Basically I am
> inserting records from reading an xml file)
>
> In the PRIMARY KEY, btree (scan_id, host_ip, port_num, plugin_id, severity,
> data) data is of type TEXT and can contain long string values.
I'm still not convinced that "data" makes a sensible part of the primary
key. Can you give an example of "data" and explain why the whole value
determines unique-ness?
> The question is how to remove this error "index row size 2728 exceeds btree
> maximum, 2713" by increasing the btree size?
>
> The big problem is "I can not add any additional column in this table."
Why not?
--
Richard Huxton
Archonet Ltd
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Richard Huxton | 2005-06-02 11:01:32 | Re: Stats not getting updated.... |
| Previous Message | Himanshu Baweja | 2005-06-02 10:38:48 | Re: Stats not getting updated.... |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ramakrishnan Muralidharan | 2005-06-02 11:13:33 | Re: [SQL] index row size 2728 exceeds btree maximum, 2713 |
| Previous Message | Martijn van Oosterhout | 2005-06-02 10:12:36 | Re: [SQL] index row size 2728 exceeds btree maximum, 2713 |