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?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.