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:

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)