Custom type column index - Postgres 9.1

From: Patrick B <patrickbakerbr(at)gmail(dot)com>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Custom type column index - Postgres 9.1
Date: 2017-01-16 21:15:31
Message-ID: CAJNY3ivEgkJRqNPAs8fVJP3z0hvL_NrGpzRTEGJXmJGKbAu72w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Lucas Possamai 2017-01-16 21:48:41 Re: Custom type column index - Postgres 9.1
Previous Message Kevin Grittner 2017-01-16 20:32:52 Re: raise notice question