Talk:Replication, Clustering, and Connection Pooling

From PostgreSQL wiki

Jump to: navigation, search

I use pg_comparator to ship deltas on a particlar table from master to slave about once every 15 minutes:

http://pgfoundry.org/projects/pg-comparator/

It's extremely efficient... working even for a fairly large (2GB) table.

Works WAY better than shipping transactions when there may be hundreds of transactions on a single row and single column in that row between the time of the last sync.

Not sure where this fits into the grid... but it's a great solution and works out-of-the box with no configuration needed. 

I tucked it in to the list of solutions, but left the grid alone.  Earonesty 14:31, 3 November 2009 (UTC)
Retrieved from "http://wiki.postgresql.org/wiki/Talk:Replication,_Clustering,_and_Connection_Pooling"
Personal tools