Re: Not sure if I should CREATE INDEX for text columns on which I plan to filter later

From: Alexander Farber <alexander(dot)farber(at)gmail(dot)com>
To:
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Not sure if I should CREATE INDEX for text columns on which I plan to filter later
Date: 2018-02-21 12:33:18
Message-ID: CAADeyWiEQvKv5oA2q+F6auRDzk3svBL1=KK_wKSd+tNmrC5R9w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi Martin -

On Wed, Feb 21, 2018 at 1:26 PM, Martin Moore <martin(dot)moore(at)avbrief(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alexander Farber 2018-02-21 12:35:46 Re: Not sure if I should CREATE INDEX for text columns on which I plan to filter later
Previous Message Martin Moore 2018-02-21 12:26:55 Re: Not sure if I should CREATE INDEX for text columns on which I plan to filter later