FearAndLoath.Us

Fear Computers. Loath Software. We are your Masters.

Monday, February 1, 2010

PostgreSQL 9 will have streaming replication

Currently, PostgreSQL replicates a database WAL (change log) files to the slave databases, which made it more difficult to get slave databases to have less than a minute of lag. This wasn’t a big deal, since before 9.0, which is in development, you couldn’t query the slave databases until you failover, which stops replication, and that’s a rare event. With streaming replication, it will be possible for the slave databases to be as little as one second out of date, which makes them much more useful for offloading read-only queries from the master database.

http://www.depesz.com/index.php/2010/02/01/waiting-for-9-0-streaming-replication/

posted by admin at 1:19 pm  

1 Comment »

  1. Awesome! I’ve set up a couple of EC2 instances to test it out.

    Comment by letterj — February 2, 2010 @ 12:16 pm

RSS feed for comments on this post. TrackBack URI

Leave a comment

Powered by WordPress