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

2018-02-22 Thread Bill Moran
On Thu, 22 Feb 2018 03:57:34 +0100 Tomas Vondra wrote: > > On 02/21/2018 05:00 PM, Bill Moran wrote: > > On Wed, 21 Feb 2018 13:33:18 +0100 > > Alexander Farber wrote: > > > >> Hi Martin - > >> > >> On Wed, Feb 21, 2018 at 1:26 PM, Martin

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

2018-02-21 Thread Bill Moran
ndexes. Even though Postgres _can_ use multiple indexes, using a single index is faster if it's available. -- Bill Moran