"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."
Some of the products that appear on this site are from companies from which QuinStreet receives compensation. This compensation may impact how and where products appear on this site including, for example, the order in which they appear. QuinStreet does not include all companies or all types of products available in the marketplace.