Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Modify existing index
- From: RPK <rpk(dot)general(at)gmail(dot)com>
- To: pgsql-general(at)postgresql(dot)org
- Subject: Modify existing index
- Date: Fri, 20 Apr 2007 21:06:50 -0700 (PDT)
- Message-id: <10113528(dot)post(at)talk(dot)nabble(dot)com>
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.
- Follow-Ups:
- Re: Modify existing index
- From: Peter Eisentraut
- Re: Modify existing index
- Prev by Date: Re: Schema relationship diagram
- Next by Date: Re: Schema relationship diagram
- Previous by thread: can't start tsearch2 in 8.2.4
- Next by thread: Re: Modify existing index
- Indexes: