Re: Custom type column index - Postgres 9.1

[Lucas Possamai <drum.lucas@xxxxxxxxx>]

2017-01-17 10:15 GMT+13:00 Patrick B <patrickbakerbr@xxxxxxxxx>:

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