Mysql/Innodb: index organized table Pg: heap table depending upon workload this ... | Hacker News

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

voganmother42 on April 9, 2017 | parent | context | favorite | on: Ask HN: What are pros and cons of PostgreSQL and M...

Mysql/Innodb: index organized table Pg: heap table

depending upon workload this can be significant.

http://use-the-index-luke.com/sql/clustering/index-organized...

SigmundA on April 9, 2017 [–]

This is a big thing I miss from SQL Server is clustered indexes. SQL server gives you the choice so you can go either way depending on situation.

Was actually kinda of surprised after using SQL server for years then looking at Pg that it didn't have IOT at all. Thought everyone had that option.

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