Home > mailing lists

Re: Performance issue with NestedLoop query - Mailing list pgsql-performance

From	Matheus de Oliveira
Subject	Re: Performance issue with NestedLoop query
Date	July 31, 2015 21:08:32
Msg-id	CAJghg4LA2Y5K3NhVV3W+v3ExPsNdMRKHep5YdAArRaubZXsphg@mail.gmail.com Whole thread Raw
In response to	Re: Performance issue with NestedLoop query (Matheus de Oliveira <matioli.matheus@gmail.com>)
List	pgsql-performance

On Fri, Jul 31, 2015 at 3:06 PM, Matheus de Oliveira <matioli.matheus@gmail.com> wrote:

CREATE INDEX ON table2 USING gin (tstzrange(start_date, end_date, '()'));

The index should be USING GIST, not GIN. Sorry.

Matheus de Oliveira

From: Matheus de Oliveira
Date: 31 July 2015, 21:06:46
Subject: Re: Performance issue with NestedLoop query

From: Qingqing Zhou
Date: 31 July 2015, 21:37:51
Subject: Re: Performance issue with NestedLoop query