| From: | Andres Freund <andres(at)anarazel(dot)de> |
|---|---|
| To: | Jim Nasby <Jim(dot)Nasby(at)BlueTreble(dot)com> |
| Cc: | Pg Hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Avoid full page images in streaming replication? |
| Date: | 2015-10-22 22:03:30 |
| Message-ID: | 20151022220330.GH14196@alap3.anarazel.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Robert Haas | 2015-10-22 22:07:06 | Re: Change behavior of (m)xid_age |
| Previous Message | Pavel Stehule | 2015-10-22 21:59:50 | Re: [PATCH] SQL function to report log message |