Re: Modify existing index - Mailing list pgsql-general

From Peter Eisentraut
Subject Re: Modify existing index
Date
Msg-id 200704210837.44254.peter_e@gmx.net
Whole thread Raw
In response to Modify existing index  (RPK <rpk.general@gmail.com>)
Responses Re: Modify existing index  (RPK <rpk.general@gmail.com>)
List pgsql-general
RPK wrote:
> I have a table and a column that is primary key. I want to modify the
> existing index and use two other columns to be used for indexing.
> Since queries will be run using these two columns, hence I want to
> use them.

The choice of what your primary key is should arise from the schema
design, not the frequency of queries.  If you are querying columns
other than the primary key, just add another index.

--
Peter Eisentraut
http://developer.postgresql.org/~petere/

pgsql-general by date:

Previous
From: William Garrison
Date:
Subject: Re: Passing arrays to stored procedures
Next
From: Tom Lane
Date:
Subject: Re: binding 64-bit integer