Index row requires 9324 bytes maximum size is 8191

Поиск
Список
Период
Сортировка
От solAris23
Тема Index row requires 9324 bytes maximum size is 8191
Дата
Msg-id 25511356.post@talk.nabble.com
обсуждение исходный текст
Ответы Re: Index row requires 9324 bytes maximum size is 8191  (Euler Taveira de Oliveira <euler@timbira.com>)
Re: Index row requires 9324 bytes maximum size is 8191  (Pavel Stehule <pavel.stehule@gmail.com>)
Re: Index row requires 9324 bytes maximum size is 8191  (Grzegorz Jaśkiewicz <gryzman@gmail.com>)
Re: Index row requires 9324 bytes maximum size is 8191  (Florian Weimer <fweimer@bfk.de>)
Список pgsql-performance

Hello,

I am trying to index a field in my database of size about 16K rows, but i m
getting this error.

" Index row requires 9324 bytes maximum size is 8191  "

Can anyone please guide me how to remove this error....

Also, average time to search for a query in a table is taking about 15
seconds. I have done indexing but the time is not reducing.....
Is there any way to reduce the time to less than 1 sec ???
The type of indexing which I am performing on the field is btree... My field
contains large text. Is there any more suitable indexing type ??

--
View this message in context:
http://www.nabble.com/Index-row-requires-9324-bytes-maximum-size-is-8191-tp25511356p25511356.html
Sent from the PostgreSQL - performance mailing list archive at Nabble.com.


В списке pgsql-performance по дате отправления:

Предыдущее
От: Michael Korbakov
Дата:
Сообщение: Planner question - wrong row count estimation
Следующее
От: Euler Taveira de Oliveira
Дата:
Сообщение: Re: Index row requires 9324 bytes maximum size is 8191