On 10/22/15 4:42 PM, Magnus Hagander wrote:
 > How are you going to make that work without LSNs in the WAL received by
 > the replica diverging from those in the master's WAL?

We could in theory send a "this would be been a fpi but it's skipped"
record which would only exist in streaming and just make the standby
write a noop of some kind? It would still be on the standby but it would
at least not consume the bandwidth. Just skip sending the actual
contents of the fpi.

I don't think it can be a noop on the receiver though... doesn't the receiver still need full page images in case of a crash? (Assuming full_page_writes is enabled...)

The other issue is chained replicas, where one of the children may need full page writes (during initial copy).
Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX
Experts in Analytics, Data Architecture and PostgreSQL
Data in Trouble? Get it in Treble! http://BlueTreble.com

Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:

Reply via email to