indexes and keys - Mailing list pgsql-sql

Greetings - I hope this is a simple question.

Is there any reason to create an index on a column that already has one
created as part of a SERIAL datatype?  That is, I used:

CREATE TABLE personal_data (id serial ...);

to create it, so \d shows:
| postgres         | personal_data                    | table    || postgres         | personal_data
|table    || postgres         | personal_data_id_key             | index    || postgres         | personal_data_id_seq
          | sequence |
 

is there any reason to create another index on id:

CREATE INDEX pd_id_idx on personal_data;

or will the automatically created one be sufficient?

Thanks.

---------------------------------------------------------------------
Andrew J. Perrin - aperrin@demog.berkeley.edu - NT/Unix Admin/Support
Department of Demography    -    University of California at Berkeley
2232 Piedmont Avenue #2120  -    Berkeley, California, 94720-2120 USA
http://demog.berkeley.edu/~aperrin --------------------------SEIU1199