Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-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

pgsql-hackers by date

Next:From: Kyle CordesDate: 2008-10-30 22:11:21
Subject: Re: Decreasing WAL size effects
Previous:From: Gregory StarkDate: 2008-10-30 21:54:01
Subject: Re: Decreasing WAL size effects

pgsql-general by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group