News for hackers. Stuff that matters.
Re:Does it scale? Who cares (2011) by qaq on Saturday April 08, 2017 @11:51PM (#14070336)
The problem is not with memory problem is that after checkpoint postgres will do full page writes for serial you will be touching way fewer pages compared to UUID so write amplification for UUID vs bigint can be 60X+
Re:Does it scale? Who cares (2011) by virmundi on Sunday April 09, 2017 @12:02AM (#14070369)
Can you go into a bit more detail? I've seen amplification referenced before. My estimation is that the database will be pretty much read heavy. I will need to split a given database across multiple instances.
Re:Does it scale? Who cares (2011) by qaq on Sunday April 09, 2017 @12:15AM (#14070425)
https://blog.2ndquadrant.com/on-the-impact-of-full-page-writ... this is fairly detailed analysis of this issue
Re:Does it scale? Who cares (2011) by virmundi on Sunday April 09, 2017 @12:47AM (#14070526)
Thank you. I'm reading over it now and for the next few days (to really grok it). I do wonder how bad it will be for low write situations. At the same time I'm open to switching to BigInt and using Postgresql-xl.
Re:Does it scale? Who cares (2011) by Dylan16807 on Sunday April 09, 2017 @04:05AM (#14071049)
How about simply using non-random UUIDs?
Re:Does it scale? Who cares (2011) by qaq on Sunday April 09, 2017 @10:57AM (#14072578)
That would def. help