Re: Modify existing index

From: RPK <rpk(dot)general(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Modify existing index
Date: 2007-04-21 07:20:45
Message-ID: 10114548.post@talk.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bjørn T Johansen 2007-04-21 08:15:40 Problem compiling PostgreSQL 8.2.3 on RedHat Enterprise Server 2.1?
Previous Message Tom Lane 2007-04-21 06:40:23 Re: binding 64-bit integer