4 ms·
how do they resolve write conflict????
by tonyhart7 1y ago
how do they resolve write conflict????
- pgedge_postgres 1y agoThe official FAQ has a good amount of info on how conflict resolution is handled (https://www.pgedge.com/resources/faq https://www.pgedge.com/resources/faq)! Relevant excerpt: "pgEdge offers eventual consistency between nodes using a configurable policy (e.g. last-writer-wins) for conflict resolution, along with conflict-free delta apply columns (i.e. CRDTs) for running sum fields. This allows for independent, concurrent and eventually consistent updates across multiple nodes." Some specific documentation on the subject: https://docs.pgedge.com/spock_ext/conflicts https://docs.pgedge.com/spock_ext/conflicts One of our solutions engineers (Paul Rothrock) created a video on this topic in the last month: https://www.youtube.com/watch?v=prkMkG0SOJE https://www.youtube.com/watch?v=prkMkG0SOJE And if you're interested in more information about conflict management in PostgreSQL clusters in general, this article ("Living on the Edge: Conflict Management and You") from Shaun Thomas is probably useful to check out: https://www.pgedge.com/blog/living-on-the-edge https://www.pgedge.com/blog/living-on-the-edge