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.
