Re: Avoid full page images in streaming replication?

Поиск
Список
Период
Сортировка
От Bernd Helmle
Тема Re: Avoid full page images in streaming replication?
Дата
Msg-id 292EA36F34951DA8248D1225@eje.credativ.lan
обсуждение исходный текст
Ответ на Re: Avoid full page images in streaming replication?  (Andres Freund <andres@anarazel.de>)
Список 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 по дате отправления:

Предыдущее
От: Bernd Helmle
Дата:
Сообщение: Re: Avoid full page images in streaming replication?
Следующее
От: Robert Haas
Дата:
Сообщение: Re: Patch (3): Implement failover on libpq connect level.