both MSSQL and Postgresql support fill factor as well, which nobody seems to mention. Setting a lower fill factor leaves more room in the pages to avoid page sp

both MSSQL and Postgresql support fill factor as well, which nobody seems to mention. Setting a lower fill factor leaves more room in the pages to avoid page splits with random writes. Also random writes can be beneficial in that you are not hot spotting the last page as you are with sequential ID's. Its not black and white, there are some good advantages with random ID's but you need to manage them properly.