Comments (2)
A quick note, I put -1 in the boundary column and now it behaves as I would expect, however I think that perhaps it should be boundary set to 0, will give you the latest, rather than one less.
from mimeo.
If the values on the column you are using as the control are always completely unique, you should be fine doing this. However, if they are not, you risk missing data if replication happens to run at the time inserts are being done and that integer value has not finished inserting all the rows that contain it. See the documentation on the p_boundary value on any of the maker functions.
If have this set at the default of 1 to ensure people setting things up using the default values do not accidentally miss any data. Yes this means that the latest value will not always be on the destination. But it ensures no data is ever missed.
from mimeo.
Related Issues (13)
- 1.3.0 error when replicating view HOT 2
- was v1.3.4 retagged? HOT 4
- (Question) Many sources for one destination for logdel replication HOT 1
- Source table in Read-Only Streaming Replication Slave server HOT 13
- (Question) ERROR: »foo« is not a view HOT 5
- Snapshot UNLOGGED source tables HOT 1
- pg_jobmon and mimeo Cannot Coexist HOT 3
- Incremental replication via serial id HOT 1
- Snapshot replication with index recreation broken? HOT 5
- FUNCTION mimeo.create_index HOT 1
- Snapshot replicated tables/views owner question HOT 2
- Handle mixed-case, special characters and reserved words in object names HOT 1
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from mimeo.