Re: Avoid full page images in streaming replication? - Mailing list pgsql-hackers

From Bernd Helmle
Subject Re: Avoid full page images in streaming replication?
Date
Msg-id 292EA36F34951DA8248D1225@eje.credativ.lan
Whole thread Raw
In response to Re: Avoid full page images in streaming replication?  (Andres Freund <andres@anarazel.de>)
List pgsql-hackers

--On 23. Oktober 2015 00:03:30 +0200 Andres Freund <andres@anarazel.de>
wrote:

> 
> Note that FPIs are often pretty good for replay performance, avoiding
> lots of synchronous random reads.

That's a very import argument, i think. The difference can be significant,
even if you have a decent storage, rendering a replica unusable. We had
examples in the past where only optimizing aggressive writes of FPIs lead
to an acceptable lag of the replica.

-- 
Thanks
Bernd



pgsql-hackers by date:

Previous
From: Bernd Helmle
Date:
Subject: Re: Avoid full page images in streaming replication?
Next
From: Robert Haas
Date:
Subject: Re: Patch (3): Implement failover on libpq connect level.