13 ms·

Impressive feature list. Glad to see logical replication is finally making it in.

• brianwawok 10y ago
  What is you use case for it? My only thought was sending just one table to replica to be used to do analytics on ..
  • bladecatcher 10y ago
    Isn't analytics a massive usecase in itself?
  • rhaas 10y ago
    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-replication.html http://rhaas.blogspot.com/2011/02/case-for-logical-replicati...
    • hodgesrm 10y ago
      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.