On 2015-10-22 16:34:38 -0500, Jim Nasby wrote: > ISTM it should be possible to avoid sending full page writes to a streaming > replica once the replica has reached a consistent state. I assume that the > replica would still need to write full pages to it's disk in case of a > crash, but the sender could insert special WAL records to tell it when to do > so, instead of sending the full page image. Presumably this would be a big > win for replication over a WAN.
Note that FPIs are often pretty good for replay performance, avoiding lots of synchronous random reads. I think FPI compression is a better solution for now. I found it to be extremely effective in some benchmarks I recently ran. Andres -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers