Postgres Pro
Downloads
Home   >   mailing lists

Thread: [GENERAL] Custom type column index - Postgres 9.1

[GENERAL] Custom type column index - Postgres 9.1

From
Patrick B
Date:
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

Re: [GENERAL] Custom type column index - Postgres 9.1

From
Lucas Possamai
Date:
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

Re: [GENERAL] Custom type column index - Postgres 9.1

From
"David G. Johnston"
Date:
On Mon, Jan 16, 2017 at 2:48 PM, Lucas Possamai <drum.lucas@gmail.com> wrote:
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?


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


​Others may be able to do without but I am sure anyone wishing to comment here would find a self-contained example to be of benefit.  If only to know exactly what your custom type looks like.

David J.
​