Modify existing index - Mailing list pgsql-general

From RPK
Subject Modify existing index
Date
Msg-id 10113528.post@talk.nabble.com
Whole thread Raw
Responses Re: Modify existing index  (Peter Eisentraut <peter_e@gmx.net>)
List 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.


pgsql-general by date:

Previous
From: RPK
Date:
Subject: Re: Schema relationship diagram
Next
From: Andreas Kretschmer
Date:
Subject: Re: Schema relationship diagram