Re: Suggestion on index creation for TEXT data field
| От | David G. Johnston |
|---|---|
| Тема | Re: Suggestion on index creation for TEXT data field |
| Дата | |
| Msg-id | CAKFQuwYtwQTZeX+buucq4gqSJwL7WQWxU7LvAJ1MEuzZa=KMrg@mail.gmail.com обсуждение исходный текст |
| Ответ на | Suggestion on index creation for TEXT data field (postgann2020 s <postgann2020@gmail.com>) |
| Ответы |
Re: Suggestion on index creation for TEXT data field
Re: Suggestion on index creation for TEXT data field Re: Suggestion on index creation for TEXT data field |
| Список | pgsql-admin |
On Thu, May 21, 2020 at 7:28 AM postgann2020 s <postgann2020@gmail.com> wrote:
which is having an avg width of 149bytes.
The average is meaningless if your maximum value exceeds a limit.
2. What type of index is the best suited for this type of data?.
And what type of data exactly are we talking about. "TEXT" is not a useful answer.
If the raw data is too large no index is going to be "best" - as the hint suggests you either need to drop the idea of indexing the column altogether or apply some function to the raw data and then index the result.
David J.
В списке pgsql-admin по дате отправления: