Linux Today: Linux News On Internet Time.

PostgreSQL 9.1 Gets Synchronous

May 02, 2011, 20:37 (0 Talkback[s])

"PostgreSQL 9.1 is now available in beta, introducing a number of new features. Among the new features is support for synchronous replication for the database.

In the beta there is also something called transaction-controlled synchronous replication, which provides control over what is and isn't replicated.

"What that means is the database administrator can decide on a per-transaction basis which ones need to be replicated and which ones don't," Josh Berkus of the PostgreSQL core team said. "The advantage of that is that there are a lot of mixed load applications which might have a small amount of essential data and a large amount of data that is not as important."

Complete Story

Related Stories: