Postgres Pro
Downloads
Home   >   mailing lists

[GENERAL] Custom type column index - Postgres 9.1 - Mailing list pgsql-general

From Patrick B
Subject [GENERAL] Custom type column index - Postgres 9.1
Date
Msg-id CAJNY3ivEgkJRqNPAs8fVJP3z0hvL_NrGpzRTEGJXmJGKbAu72w@mail.gmail.com
Whole thread Raw
Responses Re: [GENERAL] Custom type column index - Postgres 9.1
List pgsql-general
Tree view
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

pgsql-general by date:

Previous
From: Kevin Grittner
Date:
Subject: Re: [GENERAL] raise notice question
Next
From: Lucas Possamai
Date:
Subject: Re: [GENERAL] Custom type column index - Postgres 9.1