Re: Custom type column index - Postgres 9.1

From: Lucas Possamai <drum(dot)lucas(at)gmail(dot)com>
To: Patrick B <patrickbakerbr(at)gmail(dot)com>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Custom type column index - Postgres 9.1
Date: 2017-01-16 21:48:41
Message-ID: CAE_gQfWtfmiyx1n6F+6w0MuCKbsFFVGzyr2NzuJiedzi14Jucg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

2017-01-17 10:15 GMT+13:00 Patrick B <patrickbakerbr(at)gmail(dot)com>:

> Hi guys,
>
> I've got a custom data type column... The query I'm using its looking over
> 9 million rows.
>
> I've created a BTREE index but it didn't help on the speed. Is there any
> special index for custom types?
>
> Thanks
> Patrick
>

I'm also looking for this. I tried to create GIN indexes but it didn't work
well... Also Btree, not good speed.

Lucas

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message David G. Johnston 2017-01-16 21:54:01 Re: Custom type column index - Postgres 9.1
Previous Message Patrick B 2017-01-16 21:15:31 Custom type column index - Postgres 9.1