Re: Avoid full page images in streaming replication?

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: Avoid full page images in streaming replication?
Дата
Msg-id 20151022225327.GU3391@alvherre.pgsql
обсуждение исходный текст
Ответ на Re: Avoid full page images in streaming replication?  (Jim Nasby <Jim.Nasby@BlueTreble.com>)
Ответы Re: Avoid full page images in streaming replication?  (Jim Nasby <Jim.Nasby@BlueTreble.com>)
Список pgsql-hackers
Jim Nasby wrote:

> But yes, this is all very hand-wavy without any actual data on what
> percentage of the WAL stream is FPIs. Looks like pageinspect doesn't work
> for WAL... does anyone have a script/tool that breaks out what percentage of
> a WAL file is FPIs?

pg_xlogdump -z

-- 
Álvaro Herrera                http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Andres Freund
Дата:
Сообщение: Re: Avoid full page images in streaming replication?
Следующее
От: Jim Nasby
Дата:
Сообщение: Re: Change behavior of (m)xid_age