Multiple column indexes - Mailing list pgsql-general

From Garth Keesler
Subject Multiple column indexes
Date
Msg-id 45B1211C.1030001@gdcjk.com
Whole thread Raw
Responses Re: Multiple column indexes  ("Merlin Moncure" <mmoncure@gmail.com>)
List 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

pgsql-general by date:

Previous
From: Scott Ribe
Date:
Subject: Re: Spam from EnterpriseDB?
Next
From: "Merlin Moncure"
Date:
Subject: Re: Multiple column indexes