Postgres Pro
Downloads
Home   >   mailing lists

Re: [GENERAL] Custom type column index - Postgres 9.1 - Mailing list pgsql-general

From Lucas Possamai
Subject Re: [GENERAL] Custom type column index - Postgres 9.1
Date
Msg-id CAE_gQfWtfmiyx1n6F+6w0MuCKbsFFVGzyr2NzuJiedzi14Jucg@mail.gmail.com
Whole thread Raw
In response to [GENERAL] Custom type column index - Postgres 9.1  (Patrick B <patrickbakerbr@gmail.com>)
Responses Re: [GENERAL] Custom type column index - Postgres 9.1  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-general
Tree view
2017-01-17 10:15 GMT+13:00 Patrick B <patrickbakerbr@gmail.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

pgsql-general by date:

Previous
From: Patrick B
Date:
Subject: [GENERAL] Custom type column index - Postgres 9.1
Next
From: "David G. Johnston"
Date:
Subject: Re: [GENERAL] Custom type column index - Postgres 9.1