Are Indices automatically generated for primary keys?

From: Clemens Eisserer <linuxhippy(at)gmail(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Are Indices automatically generated for primary keys?
Date: 2010-08-18 13:51:22
Message-ID: AANLkTin-+Ezh_dFq5YjFoPhaN32QiiJigwP=hLm91+yK@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-performance

Hi,

Are indices for columns marked with "PRIMARY KEY" automatically generated by
postgresql, or do I have to do it manually?
The question might seem dumb, I ask because I remember from working with
MySQL it generates indices automatically in this case.

Thank you in advance, Clemens

Responses

Browse pgsql-general by date

  From Date Subject
Next Message hubert depesz lubaczewski 2010-08-18 13:54:56 Re: Are Indices automatically generated for primary keys?
Previous Message Derrick Rice 2010-08-18 13:48:50 Warm Standby and resetting the primary as a standby

Browse pgsql-performance by date

  From Date Subject
Next Message hubert depesz lubaczewski 2010-08-18 13:54:56 Re: Are Indices automatically generated for primary keys?
Previous Message Tom Lane 2010-08-18 13:22:02 Re: Fwd: Vacuum Full + Cluster + Vacuum full = non removable dead rows