PostgreSQL really is the world's best database, but isn't perfect.https://medium.com/@rbranson/10-things-i-hate-about-postgresql-20dbab8c2791 …
-
-
Syncrep can be enabled/disabled on a per-transaction basis, which allows it to be used in more situations. Often a high % of tx don't have that high durability requirements. The latency impact is paid once per transaction, and can often be amortized across parallel commits.
-
Your description of full page writes is off btw, significantly overstating the overhead. Not required for every modification, only if page has not been modified since the last checkpoint. Enabling checksums can address a significant part of the "corruption propagation" concern.
End of conversation
New conversation -
Loading seems to be taking a while.
Twitter may be over capacity or experiencing a momentary hiccup. Try again or visit Twitter Status for more information.