Re: Values larger than 1/3 of a buffer page cannot be indexed.
| От | Dmitriy Igrishin |
|---|---|
| Тема | Re: Values larger than 1/3 of a buffer page cannot be indexed. |
| Дата | |
| Msg-id | AANLkTikG_nHARKr9qeQXpS7Q6QXgJvuFUi6Wxpd0o7H7@mail.gmail.com обсуждение исходный текст |
| Ответ на | Values larger than 1/3 of a buffer page cannot be indexed. (Viktor Nagy <viktor.nagy@toolpart.hu>) |
| Ответы |
Re: Values larger than 1/3 of a buffer page cannot be
indexed.
Re: Values larger than 1/3 of a buffer page cannot be indexed. |
| Список | pgsql-general |
Hey Viktor,
--
// Dmitriy.
2011/3/13 Viktor Nagy <viktor.nagy@toolpart.hu>
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)?
Just create index this way, e.g.
CREATE INDEX ir_translation_ltns ON tab ((md5(col)));
where "tab" and "col" are table and column of which you want
to create btree index.
CREATE INDEX ir_translation_ltns ON tab ((md5(col)));
where "tab" and "col" are table and column of which you want
to create btree index.
thanks,
Viktor
--
// Dmitriy.
В списке pgsql-general по дате отправления: