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

From Craig Ringer
Subject Re: Decreasing WAL size effects
Date
Msg-id 490AAE73.2060003@postnewspapers.com.au
Whole thread Raw
In response to Re: Decreasing WAL size effects  (Jason Long <mailing.list@supernovasoftware.com>)
Responses Re: Decreasing WAL size effects  (Craig Ringer <craig@postnewspapers.com.au>)
List pgsql-general
Jason Long wrote:
> Greg Smith wrote:
>> On Thu, 30 Oct 2008, Tom Lane wrote:
>>
>>> The real reason not to put that functionality into core (or even
>>> contrib) is that it's a stopgap kluge.  What the people who want this
>>> functionality *really* want is continuous (streaming) log-shipping, not
>>> WAL-segment-at-a-time shipping.
>>
>> Sure, and that's why I didn't care when this got kicked out of the
>> March CommitFest; was hoping a better one would show up.  But if 8.4
>> isn't going out the door with the feature people really want, it would
>> be nice to at least make the stopgap kludge more easily available.
> +1
> Sure I would rather have synchronous WAL shipping, but  if that is going
> to be a while or synchronous would slow down my applicaton I  can get
> comfortably close enough for my purposes with some highly compressible
> WALs.

I also tend to agree; it'd be really handy. pg_clearxlogtail (which I
use) makes me nervous despite the restore tests I've done.

If Pg truncated the WAL files before calling archive_command, and would
accept truncated WAL files on restore, that'd be really useful. Failing
that, packaging pg_clearxlogtail so it was kept in sync with the main Pg
code would be a big step.

--
Craig Ringer

pgsql-general by date:

Previous
From: Kyle Cordes
Date:
Subject: Re: Decreasing WAL size effects
Next
From: "Jodok Batlogg"
Date:
Subject: tsearch2 problem