Postgres Pro
Downloads
Home   >   mailing lists

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

From hubert depesz lubaczewski
Subject Re: Are Indices automatically generated for primary keys?
Date
Msg-id 20100818135456.GA17355@depesz.com
Whole thread Raw
In response to Are Indices automatically generated for primary keys?  (Clemens Eisserer <linuxhippy@gmail.com>)
List pgsql-performance
Tree view 
On Wed, Aug 18, 2010 at 03:51:22PM +0200, Clemens Eisserer wrote:
> 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.

they are generated automatically.

Best regards,

depesz

--
Linkedin: http://www.linkedin.com/in/depesz  /  blog: http://www.depesz.com/
jid/gtalk: depesz@depesz.com / aim:depeszhdl / skype:depesz_hdl / gg:6749007

pgsql-performance by date:

Previous
From: Clemens Eisserer
Date:
Subject: Are Indices automatically generated for primary keys?
Next
From: "Kevin Grittner"
Date:
Subject: Re: Are Indices automatically generated for primary keys?