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

From Bruno Wolff III
Subject Re: [SQL] index row size 2728 exceeds btree maximum, 27
Date
Msg-id 20050602193324.GA2861@wolff.to
Whole thread Raw
In response to Re: [SQL] index row size 2728 exceeds btree maximum, 27  (Richard Huxton <dev@archonet.com>)
Responses Re: [SQL] index row size 2728 exceeds btree maximum, 27  (Richard Huxton <dev@archonet.com>)
List pgsql-general
On Thu, Jun 02, 2005 at 18:00:17 +0100,
  Richard Huxton <dev@archonet.com> wrote:
>
> Certainly, but if the text in the logfile row is the same, then hashing
> isn't going to make a blind bit of difference. That's the root of my
> concern, and something only Dinesh knows.

Sure it is. Because the hash can be used in the primary key instead of
of the error message which should reduce the size of the key enough
that he can use a btree index.

pgsql-general by date:

Previous
From: Joachim Zobel
Date:
Subject: Limits of SQL
Next
From: Ben
Date:
Subject: Re: Limits of SQL