Re: [SQL] index row size 2728 exceeds btree maximum, 27

Поиск
Список
Период
Сортировка
От Bruno Wolff III
Тема Re: [SQL] index row size 2728 exceeds btree maximum, 27
Дата
Msg-id 20050602193324.GA2861@wolff.to
обсуждение исходный текст
Ответ на Re: [SQL] index row size 2728 exceeds btree maximum, 27  (Richard Huxton <dev@archonet.com>)
Ответы Re: [SQL] index row size 2728 exceeds btree maximum, 27  (Richard Huxton <dev@archonet.com>)
Список 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 по дате отправления:

Предыдущее
От: Joachim Zobel
Дата:
Сообщение: Limits of SQL
Следующее
От: Ben
Дата:
Сообщение: Re: Limits of SQL