Re: Decreasing WAL size effects - Mailing list pgsql-general

From Gregory Stark
Subject Re: Decreasing WAL size effects
Date
Msg-id 87abclbvgm.fsf@oxford.xeocode.com
Whole thread Raw
In response to Re: Decreasing WAL size effects  (Greg Smith <gsmith@gregsmith.com>)
Responses Re: Decreasing WAL size effects  (Christophe <xof@thebuild.com>)
Re: Decreasing WAL size effects  (Kyle Cordes <kyle@kylecordes.com>)
Re: Decreasing WAL size effects  (Greg Smith <gsmith@gregsmith.com>)
List pgsql-general
Greg Smith <gsmith@gregsmith.com> writes:

> Now, it would be possible to have that less sensitive archive code path zero
> things out, but you'd need to introduce a way to note when it's been done (so
> you don't do it for a segment twice) and a way to turn it off so everybody
> doesn't go through that overhead (which probably means another GUC).  That's a
> bit much trouble to go through just for a feature with a fairly limited
> use-case that can easily live outside of the engine altogether.

Wouldn't it be just as good to indicate to the archive command the amount of
real data in the wal file and have it only bother copying up to that point?

--
  Gregory Stark
  EnterpriseDB          http://www.enterprisedb.com
  Ask me about EnterpriseDB's Slony Replication support!

pgsql-general by date:

Previous
From: Alan Hodgson
Date:
Subject: Re: speed up restore from dump
Next
From: Berend Tober
Date:
Subject: Re: Schema Upgrade Howto