Re: Modify existing index - Mailing list pgsql-general

From RPK
Subject Re: Modify existing index
Date
Msg-id 10114548.post@talk.nabble.com
Whole thread Raw
In response to Re: Modify existing index  (Peter Eisentraut <peter_e@gmx.net>)
Responses Re: Modify existing index  ("A. Kretschmer" <andreas.kretschmer@schollglas.com>)
List pgsql-general
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.


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: binding 64-bit integer
Next
From: Bjørn T Johansen
Date:
Subject: Problem compiling PostgreSQL 8.2.3 on RedHat Enterprise Server 2.1?