On Mon, Jan 16, 2017 at 2:48 PM, Lucas Possamai <drum.lu...@gmail.com> wrote:
> 2017-01-17 10:15 GMT+13:00 Patrick B <patrickbake...@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.