Postgres Pro
Downloads
Home   >   mailing lists

Are Indices automatically generated for primary keys? - Mailing list pgsql-performance

From Clemens Eisserer
Subject Are Indices automatically generated for primary keys?
Date
Msg-id AANLkTin-+Ezh_dFq5YjFoPhaN32QiiJigwP=hLm91+yK@mail.gmail.com
Whole thread Raw
Responses Re: Are Indices automatically generated for primary keys?  (hubert depesz lubaczewski <depesz@depesz.com>)
Re: Are Indices automatically generated for primary keys?  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
List pgsql-performance
Tree view
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

pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: Fwd: Vacuum Full + Cluster + Vacuum full = non removable dead rows
Next
From: hubert depesz lubaczewski
Date:
Subject: Re: Are Indices automatically generated for primary keys?