Postgres Pro
Downloads
Home   >   mailing lists

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

From Alvaro Herrera
Subject Re: Avoid full page images in streaming replication?
Date
Msg-id 20151022225327.GU3391@alvherre.pgsql
Whole thread Raw
In response to Re: Avoid full page images in streaming replication?  (Jim Nasby <Jim.Nasby@BlueTreble.com>)
Responses Re: Avoid full page images in streaming replication?  (Jim Nasby <Jim.Nasby@BlueTreble.com>)
List pgsql-hackers
Tree view 
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 by date:

Previous
From: Andres Freund
Date:
Subject: Re: Avoid full page images in streaming replication?
Next
From: Jim Nasby
Date:
Subject: Re: Change behavior of (m)xid_age