Suggestion on index creation for TEXT data field

Поиск
Список
Период
Сортировка
От postgann2020 s
Тема Suggestion on index creation for TEXT data field
Дата
Msg-id CANynezMUb3xF4Tuj5a4CH+BYNkPxfAQR3qg5ExRTuuWc8veRJg@mail.gmail.com
обсуждение исходный текст
Ответы Re: Suggestion on index creation for TEXT data field  ("David G. Johnston" <david.g.johnston@gmail.com>)
Re: Suggestion on index creation for TEXT data field  ("David G. Johnston" <david.g.johnston@gmail.com>)
Re: Suggestion on index creation for TEXT data field  ("David G. Johnston" <david.g.johnston@gmail.com>)
Re: Suggestion on index creation for TEXT data field  (Adrian Klaver <adrian.klaver@aklaver.com>)
Re: Suggestion on index creation for TEXT data field  (Adrian Klaver <adrian.klaver@aklaver.com>)
Re: Suggestion on index creation for TEXT data field  (Adrian Klaver <adrian.klaver@aklaver.com>)
Список pgsql-admin
Hi Team,
Thanks for your support.
Could you please suggest on below query.

Environment

PostgreSQL: 9.5.15
Postgis: 2.2.7
Mostly table contains GIS data and we are trying to creating an index on the column which is having an avg width of 149bytes.

 CREATE INDEX index_idx
  ON SCHEMA.TABLE
  USING btree
  (column);

ERROR:  index row size 2976 exceeds maximum 2712 for index "index_idx"
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.

Could you please suggest on below queries.
1. How to solve the issue?.
2. What type of index is the best suited for this type of data?.

Thanks for your support.

Regards,
PostgAnn.

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

Предыдущее
От: postgann2020 s
Дата:
Сообщение: Suggestion to improve query performance.
Следующее
От: "David G. Johnston"
Дата:
Сообщение: Re: Suggestion on index creation for TEXT data field