--On 23. Oktober 2015 00:03:30 +0200 Andres Freund <[email protected]>
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
--
Sent via pgsql-hackers mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
