Thread: Modify existing index

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.

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/

How to see the details of indexes being used by a table? If I want to drop an
index, how can I do that?


>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.

--
View this message in context: http://www.nabble.com/Modify-existing-index-tf3621688.html#a10114548
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

am  Sat, dem 21.04.2007, um  0:20:45 -0700 mailte RPK folgendes:
>
> How to see the details of indexes being used by a table? If I want to drop an

Within psql, type '\d <tablename>'.


> index, how can I do that?

DROP <INDEX>, perhaps with option CASCADE.

Please read our documentation...


Andreas
--
Andreas Kretschmer
Kontakt:  Heynitz: 035242/47150,   D1: 0160/7141639 (mehr: -> Header)
GnuPG-ID:   0x3FFF606C, privat 0x7F4584DA   http://wwwkeys.de.pgp.net