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 Alexander Farber
Subject Re: Not sure if I should CREATE INDEX for text columns on which Iplan to filter later
Date
Msg-id CAADeyWiEQvKv5oA2q+F6auRDzk3svBL1=KK_wKSd+tNmrC5R9w@mail.gmail.com
Whole thread Raw
In response to Re: Not sure if I should CREATE INDEX for text columns on which Iplan to filter later  (Martin Moore <martin.moore@avbrief.com>)
Responses Re: Not sure if I should CREATE INDEX for text columns on which Iplan to filter later  (Alexander Farber <alexander.farber@gmail.com>)
Re: Not sure if I should CREATE INDEX for text columns on which Iplan to filter later  (Bill Moran <wmoran@potentialtech.com>)
Re: Not sure if I should CREATE INDEX for text columns on which Iplan to filter later  (Martin Moore <martin.moore@avbrief.com>)
Re: Not sure if I should CREATE INDEX for text columns on which Iplan to filter later  (Tomas Vondra <tomas.vondra@2ndquadrant.com>)
List pgsql-general
Tree view
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: Martin Moore
Date:
Subject: Re: Not sure if I should CREATE INDEX for text columns on which Iplan to filter later
Next
From: Alexander Farber
Date:
Subject: Re: Not sure if I should CREATE INDEX for text columns on which Iplan to filter later