Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search for
  Advanced Search

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: Sat, 21 Apr 2007 00:20:45 -0700 (PDT)
  • Message-id: <10114548(dot)post(at)talk(dot)nabble(dot)com>

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.




Home | Main Index | Thread Index

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group