#TIL SQL Server and MySQL PRIMARY KEY is, by default, clustered (and SQL Server can change a primary key to non-clustered if specified). Whereas in PostgreSQL, PRIMARY KEY is essentially a non-nullable unique index and clustering is specified separately. #DirtyDetails