2 ms·
Anecdotal data point: No problems. It's been rock stable for a couple of years now. Even though we have 22 databases on our master, the streaming replication ov
by lobster_johnson 14y ago
Anecdotal data point: No problems. It's been rock stable for a couple of years now. Even though we have 22 databases on our master, the streaming replication overhead is practically zero, and the latency is usually in the order of milliseconds.
We did have a weird replication failure at one point when running pg_repack. It's a tool that reclusters tables by duplicating them (essentially writing a new table sequentially) and then renaming the duplicate back to the original table name. This caused the slave to suddenly try to access a table that had not been created on its end yet. But it's possible that it was due to misconfiguration; we are currently investigating it so we can collect enough to data to maybe submit a bug report.
Postgres-XC looks interesting, but I have not heard of anyone using it in production yet. Would love to hear if anyone has used it for anything serious.