Postgres Pro
Downloads
Home   >   mailing lists

Re: Not sure if I should CREATE INDEX for text columns on which Iplan to filter later - Mailing list pgsql-general

From Martin Moore
Subject Re: Not sure if I should CREATE INDEX for text columns on which Iplan to filter later
Date
Msg-id AC56C946-8609-4544-9E1C-EB512928BF48@avbrief.com
Whole thread Raw
In response to Re: Not sure if I should CREATE INDEX for text columns on which Iplan to filter later  (Alexander Farber <alexander.farber@gmail.com>)
List pgsql-general
Tree view

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 by date:

Previous
From: Bill Moran
Date:
Subject: Re: Not sure if I should CREATE INDEX for text columns on which Iplan to filter later
Next
From: Alvaro Aguayo Garcia-Rada
Date:
Subject: Re: Installing 9.6.6 to a RHEL 6.7 server with no Internet access