Re: Modify existing index

[Peter Eisentraut <peter_e(at)gmx(dot)net>]

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/