Values larger than 1/3 of a buffer page cannot be indexed.

From: Viktor Nagy <viktor(dot)nagy(at)toolpart(dot)hu>
To: pgsql-general(at)postgresql(dot)org
Subject: Values larger than 1/3 of a buffer page cannot be indexed.
Date: 2011-03-13 14:53:58
Message-ID: AANLkTin3p6VS1Z=TtqUV-5cG4TZpTjUMfuPNzWJFgnr5@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

hi,

when trying to insert a long-long value, I get the following error:

index row size 3120 exceeds maximum 2712 for index "ir_translation_ltns"
HINT: Values larger than 1/3 of a buffer page cannot be indexed.
Consider a function index of an MD5 hash of the value, or use full text
indexing.

is there a way to generate this recommended function index of an md5 hash on
an already existing database and tables (filled with data)?

thanks,
Viktor

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Dmitriy Igrishin 2011-03-13 18:05:14 Re: Values larger than 1/3 of a buffer page cannot be indexed.
Previous Message ray 2011-03-12 14:54:58 Re: Ad hoc report writer