Talk:Replication, Clustering, and Connection Pooling

From PostgreSQL wiki

Revision as of 14:31, 3 November 2009 by Earonesty (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
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)
Personal tools