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

From Greg Smith
Subject Re: Decreasing WAL size effects
Date
Msg-id Pine.GSO.4.64.0810301816030.17166@westnet.com
Whole thread Raw
In response to Re: Decreasing WAL size effects  (Gregory Stark <stark@enterprisedb.com>)
Responses Re: Decreasing WAL size effects  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
On Thu, 30 Oct 2008, 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?

That pushes the problem of writing a little chunk of code that reads only
the right amount of data and doesn't bother compressing the rest onto the
person writing the archive command.  Seems to me that leads back towards
wanting to bundle a contrib module with a good implementation of that with
the software.  The whole tail clearing bit is in the same situation
pg_standby was circa 8.2:  the software is available, and it works, but it
seems kind of sketchy to those not familiar with the source of the code.
Bundling it into the software as a contrib module just makes that problem
go away for end-users.

--
* Greg Smith gsmith@gregsmith.com http://www.gregsmith.com Baltimore, MD

pgsql-general by date:

Previous
From: Kyle Cordes
Date:
Subject: Re: Decreasing WAL size effects
Next
From: "Scott Marlowe"
Date:
Subject: Re: Are there plans to add data compression feature to postgresql?