1/17/2024 0 Comments Postgres vs mysql uber![]() PostgreSQL replicas certainly allow access to data with full MVCC semantics. Later, this comment leads to the conclusion “Postgres replicas … can’t implement MVCC” which is wholly incorrect and a major misunderstanding. If you’re not using it, please consider doing so. This is supported from PostgreSQL 9.1 (2011) and above. This is true, though misses the point that a parameter exists to control that behaviour, so that when hot_standby_feedback = on the described behaviour does not occur in normal circumstances. In this situation, Postgres pauses the WAL application thread until the transaction has ended.” “If a streaming replica has an open transaction, updates to the database are blocked if they affect rows held open by the transaction. ![]() ![]() To do this, detailed follow-ups are noted for immediate action. Having said that, I very much welcome the raising of those points and also wish to show that the PostgreSQL project and 2ndQuadrant are responsive to feedback. This document looks in detail at those points to ensure we have detailed information available for a wider audience, so nobody is confused by PostgreSQL’s capabilities. This is no doubt because the post was actually written some time/years? ago and only recently published. ![]() In most cases, those limitations were actually true in the distant past of 5-10 years ago, so that leaves us with the impression of comparing MySQL as it is now with PostgreSQL as it was a decade ago. Regrettably, a number of important technical points are either not correct or not wholly correct because they overlook many optimizations in PostgreSQL that were added specifically to address the cases discussed. PostgreSQL 9 Cookbook – Chinese EditionĪn Uber technical blog of July 2016 described the perception of “many Postgres limitations”.PostgreSQL Server Programming Cookbook – 2nd Edition.PostgreSQL 9 Administration Cookbook – 3rd Edition.PostgreSQL High Availability Cookbook – 2nd Edition. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |