Modify existing index

From: RPK <rpk(dot)general(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Modify existing index
Date: 2007-04-21 04:06:50
Message-ID: 10113528.post@talk.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


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.
Can I modify the existing index using pgAdmin? Which type of index will suit
this table? B-Tree, Hash ...? This table has frequent insertions but rare
updates.
--
View this message in context: http://www.nabble.com/Modify-existing-index-tf3621688.html#a10113528
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andreas Kretschmer 2007-04-21 04:59:01 Re: Schema relationship diagram
Previous Message RPK 2007-04-21 04:03:16 Re: Schema relationship diagram