Multiple column indexes

From: Garth Keesler <garthk(at)gdcjk(dot)com>
To: PGGeneral <pgsql-general(at)postgresql(dot)org>
Subject: Multiple column indexes
Date: 2007-01-19 19:50:52
Message-ID: 45B1211C.1030001@gdcjk.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I have a primary key made up of two varchar(128) columns, typically less
than 16 chars each. Concatenating the two columns would still be unique.
Would it make sense to concat the two columns, using a unique separator
like '~' and index on that single column or would that be more trouble
than the potential performance gains?

Thanx,
Garth

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Merlin Moncure 2007-01-19 19:53:45 Re: Multiple column indexes
Previous Message Scott Ribe 2007-01-19 19:12:57 Re: Spam from EnterpriseDB?