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

From Kyle Cordes
Subject Re: Decreasing WAL size effects
Date
Msg-id 490A3109.8060602@kylecordes.com
Whole thread Raw
In response to Re: Decreasing WAL size effects  (Gregory Stark <stark@enterprisedb.com>)
List pgsql-general
Gregory Stark wrote:
> Greg Smith <gsmith@gregsmith.com> writes:
>
> 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?

That sounds like a great solution to me; ideally it would be done in a
way that is always on (i.e. no setting, etc.).

On the log-recovery side, PG would need to be willing to accept
shorter-than-usual segments, if it's not already willing.


--
Kyle Cordes
http://kylecordes.com

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Are there plans to add data compression feature to postgresql?
Next
From: Greg Smith
Date:
Subject: Re: Decreasing WAL size effects