Re:New Features Coming in PostgreSQL 10
by hodgesrm on Saturday April 08, 2017 @11:11AM
(#14067280)
Impressive feature list. Glad to see logical replication is finally making it in.
[ Parent
| on HN ]
Re:New Features Coming in PostgreSQL 10
by brianwawok on Saturday April 08, 2017 @11:15AM
(#14067310)
What is you use case for it? My only thought was sending just one table to replica to be used to do analytics on
..
Replication across major versions, for example to upgrade without downtime. Partial replication, to distribute shared data across a series of clusters, or for analytics and reporting as you mention. Replicating the data without replicating any table bloat. Being able to do limited writes (e.g. to temporary tables) on the standby. http://rhaas.blogspot.com/2011/02/case-for-logical-replicati...
Indeed--anything where you want the secondary to be other than a bit-for-bit copy of the primary. It's also convenient for HA in some cases due to the fact that the DBMS copies are fully independent, hence free from propagated bit-level errors and also available for unimpeded reads.
MySQL started with logical replication very early on and it has proven extraordinarily useful. One of the more interesting use cases is feeding log transactions into data warehouses, which should be possible in PostgreSQL 10.
Re:New Features Coming in PostgreSQL 10
by bladecatcher on Saturday April 08, 2017 @11:25AM
(#14067358)
Isn't analytics a massive usecase in itself?