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

2017-01-16 Thread David G. Johnston
On Mon, Jan 16, 2017 at 2:48 PM, Lucas Possamai wrote: > 2017-01-17 10:15 GMT+13:00 Patrick B : > >> 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 >> speci

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

2017-01-16 Thread Lucas Possamai
2017-01-17 10:15 GMT+13:00 Patrick B : > 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

[GENERAL] Custom type column index - Postgres 9.1

2017-01-16 Thread Patrick B
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