Re: Decreasing WAL size effects

From: Christophe <xof(at)thebuild(dot)com>
To: pgsql List <pgsql-general(at)postgresql(dot)org>
Subject: Re: Decreasing WAL size effects
Date: 2008-10-30 21:57:58
Message-ID: AB10E478-B4C5-448F-B7F7-3E5079EB19ED@thebuild.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers


On Oct 30, 2008, at 2:54 PM, Gregory Stark wrote:
> 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?

Hm! Interesting question: Can the WAL files be truncated, rather
than zeroed, safely?

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Gregory Stark 2008-10-30 22:01:10 Re: Are there plans to add data compression feature to postgresql?
Previous Message Gregory Stark 2008-10-30 21:54:01 Re: Decreasing WAL size effects

Browse pgsql-hackers by date

  From Date Subject
Next Message Kyle Cordes 2008-10-30 22:11:21 Re: Decreasing WAL size effects
Previous Message Gregory Stark 2008-10-30 21:54:01 Re: Decreasing WAL size effects