News for hackers. Stuff that matters.
Re:Design better databases by ddorian43 on Thursday April 07, 2016 @05:08PM (#11450741)
Actually only postgresql does it this way (by storing data in the heap and not in the primary index). Mysql(innodb),mssql,oracle uses the store the row in the primary-key.

Edit: I'm ~wrong, see below.

Re:Design better databases by ww520 on Thursday April 07, 2016 @05:51PM (#11450995)
Only Innodb does it by default. The others use heap table by default.

MSSQL allows clustered indexed table as an option to order the physical storage of rows. Oracle has index-organized table as an option.

Edit: They don't use clustered indexed table by default because record insertion is very expensive since clustered index forces the table to store the records contiguously in the index's order. Also Innodb is not truely clustered indexed. It only stores records contiguously for one page at the B+ Tree leaf level. Records in different pages are scattered all over even if the index values are sequential.

Re:Design better databases by Jweb_Guru on Thursday April 07, 2016 @06:14PM (#11451127)
It's pretty variable, but Postgres definitely is not the only one that does it that way (or even close).