Re: Decreasing WAL size effects

From: Kyle Cordes <kyle(at)kylecordes(dot)com>
To: pgsql <pgsql-general(at)postgresql(dot)org>
Subject: Re: Decreasing WAL size effects
Date: 2008-10-30 22:11:21
Message-ID: 490A3109.8060602@kylecordes.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

Gregory Stark wrote:
> Greg Smith <gsmith(at)gregsmith(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Greg Smith 2008-10-30 22:23:03 Re: Decreasing WAL size effects
Previous Message Tom Lane 2008-10-30 22:03:52 Re: Are there plans to add data compression feature to postgresql?

Browse pgsql-hackers by date

  From Date Subject
Next Message Greg Smith 2008-10-30 22:23:03 Re: Decreasing WAL size effects
Previous Message Christophe 2008-10-30 21:57:58 Re: Decreasing WAL size effects