News for hackers. Stuff that matters.

A comment on Design better databases. Parent comment

Re:Design better databases by wiredfool on Thursday April 07, 2016 @03:20PM (#11449853)
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.

[ Parent | on HN ]
Re:Design better databases by mortehu on Thursday April 07, 2016 @03:29PM (#11449940)
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

[ Parent | on HN ]