Peter Geoghegan on Twitter: "@craigkerstiens @plukevdh They're equivalent in how they perform." / Twitter

Postgres folks: is a PRIMARY_KEY implemented as a unique, non-null index?

1

Replying to

yep postgresql.org/docs/9.4/stati

1

Replying to

do you know of any reason the performance would differ between the two?

1

Replying to

you mean creating a PK vs. a unique index not null ?

1

Replying to

yup

1

Replying to

hmm, no idea, wonder if the planner gives slightly different semantics,

@petervgeoghegan

may know better?

1

Replying to

They're equivalent in how they perform.

6:40 PM · Jun 30, 2015Twitter Web Client

Replying to

thank you!

Replying to

are there any major reasons to differentiate between the two?

Conversation