I don't believe that the Primary Key affects the physical ordering of records in... | Hacker News

Hacker Newsnew | past | comments | ask | show | jobs | submit

wiredfool on April 7, 2016 | parent | context | favorite | on: Design better databases

I don't believe that the Primary Key affects the physical ordering of records in PostgreSQL.

Primary Key is implemented as a unique index coupled with a not null constraint. It's essentially syntactic sugar.

mortehu on April 7, 2016 [–]

To elaborate, even if you do call CLUSTER[1] to enforce a physical ordering, the primary key is not the default (there is no default).

1. http://www.postgresql.org/docs/9.5/static/sql-cluster.html

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact