Hi there,

I'd like to know when I create a primary key on a table, does postgres will 
create automatically an index on that table related to the primary key 
columns, or I have to create it explicitly ?

If I have to create it explicitly, suppose I have tables with a serial 
primary key, or link tables with multiple column primary key. How is 
recommended for the two cases: to create an index on the primary key unique, 
or cluster or both or with none of the two options ?

TIA,
Sabin 



---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

               http://archives.postgresql.org

Reply via email to