Haas: New Features Coming in PostgreSQL 10

Here's anextensive summary of new features in the upcoming PostgreSQL 10 releasefrom Robert Haas. "PostgreSQL has had physical replication -- oftencalled streaming replication -- since version 9.0, but this requiresreplicating the entire database, cannot tolerate writes in any form on thestandby server, and is useless for replicating across versions or databasesystems. PostgreSQL has had logical decoding -- basically change capture-- since version 9.4, which has been embraced with enthusiasm, but it couldnot be used for replication without an add-on of some sort. PostgreSQL 10adds logical replication which is very easy to configure and which works attable granularity, clearly a huge step forward. It will copy the initialdata for you and then keep it up to date after that."