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

From: Martin Moore <martin(dot)moore(at)avbrief(dot)com>
To: Bill Moran <wmoran(at)potentialtech(dot)com>
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 16:16:48
Message-ID: 6F60E3C6-1F7C-490E-AF6B-70665B1EFBBA@avbrief.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


> However, Martin's other comment about only using a single index is incorrect.
> Postgres can use multiple indexes per query, so it's often good practace to
> put indexes on every column that might ever be used in a WHERE clause.

> --
> Bill Moran <wmoran(at)potentialtech(dot)com>

That's very useful to know!

Martin.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Julián Jiménez González 2018-02-21 17:15:54 Building PostgreSQL old version from source to test vulnerability CVE-2017-7546
Previous Message Alvaro Aguayo Garcia-Rada 2018-02-21 16:03:34 Re: Installing 9.6.6 to a RHEL 6.7 server with no Internet access