Re: Not sure if I should CREATE INDEX for text columns on which Iplan to filter later
От | Martin Moore |
---|---|
Тема | Re: Not sure if I should CREATE INDEX for text columns on which Iplan to filter later |
Дата | |
Msg-id | C727B340-40F8-4E18-846A-C1E6F14181D8@avbrief.com обсуждение исходный текст |
Ответ на | Not sure if I should CREATE INDEX for text columns on which I plan tofilter later (Alexander Farber <alexander.farber@gmail.com>) |
Ответы |
Re: Not sure if I should CREATE INDEX for text columns on which Iplan to filter later
(Alexander Farber <alexander.farber@gmail.com>)
|
Список | pgsql-general |
I’m no expert but I’d think it unlikely an index would be considered for a table with only 100 rows in. Also I’m pretty sure only one index per table is used, so you’d want to put state1 and state2 in one index.
You may wish to consider normalising too – so any field with a 1 or 2 at the end is moved to a separate table linked by gid. This would also help the indexing.
Martin.
From: Alexander Farber <alexander.farber@gmail.com>
Date: Wednesday, 21 February 2018 at 12:16
To: pgsql-general <pgsql-general@postgresql.org>
Subject: Not sure if I should CREATE INDEX for text columns on which I plan to filter later
В списке pgsql-general по дате отправления:
Предыдущее
От: Alexander FarberДата:
Сообщение: Not sure if I should CREATE INDEX for text columns on which I plan tofilter later
Следующее
От: Alexander FarberДата:
Сообщение: Re: Not sure if I should CREATE INDEX for text columns on which Iplan to filter later