Re: Performance issue with NestedLoop query

From: Matheus de Oliveira <matioli(dot)matheus(at)gmail(dot)com>
To: Ram N <yramiyer(at)gmail(dot)com>
Cc: pgsql-performance <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Performance issue with NestedLoop query
Date: 2015-07-31 18:08:08
Message-ID: CAJghg4LA2Y5K3NhVV3W+v3ExPsNdMRKHep5YdAArRaubZXsphg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Fri, Jul 31, 2015 at 3:06 PM, Matheus de Oliveira <
matioli(dot)matheus(at)gmail(dot)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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Qingqing Zhou 2015-07-31 18:37:41 Re: Performance issue with NestedLoop query
Previous Message Matheus de Oliveira 2015-07-31 18:06:23 Re: Performance issue with NestedLoop query