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 AC56C946-8609-4544-9E1C-EB512928BF48@avbrief.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
Дерево обсуждения

My point was that your explain would be the same with indexes as without as they won’t be used.

 

Martin.

 

From: Alexander Farber <alexander.farber@gmail.com>
Date: Wednesday, 21 February 2018 at 12:33
Cc: pgsql-general <pgsql-general@postgresql.org>
Subject: Re: Not sure if I should CREATE INDEX for text columns on which I plan to filter later

 

Hi Martin -

 

On Wed, Feb 21, 2018 at 1:26 PM, Martin Moore <martin.moore@avbrief.com> wrote:

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.

 

I hope to have more records in the words_games table later when my game is launched (currently in soft launch/beta).....

Regards

Alex

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

Предыдущее
От: Bill Moran
Дата:
Сообщение: Re: Not sure if I should CREATE INDEX for text columns on which Iplan to filter later
Следующее
От: Alvaro Aguayo Garcia-Rada
Дата:
Сообщение: Re: Installing 9.6.6 to a RHEL 6.7 server with no Internet access