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

Re: Decreasing WAL size effects

From: Craig Ringer <craig(at)postnewspapers(dot)com(dot)au>
To: Jason Long <mailing(dot)list(at)supernovasoftware(dot)com>
Cc: Greg Smith <gsmith(at)gregsmith(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>,Gregory Stark <stark(at)enterprisedb(dot)com>,Kyle Cordes <kyle(at)kylecordes(dot)com>,pgsql <pgsql-general(at)postgresql(dot)org>
Subject: Re: Decreasing WAL size effects
Date: 2008-10-31 07:06:27
Message-ID: 490AAE73.2060003@postnewspapers.com.au (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-hackers
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

In response to

Responses

pgsql-hackers by date

Next:From: Heikki LinnakangasDate: 2008-10-31 07:40:04
Subject: Re: PG_PAGE_LAYOUT_VERSION 5 - time for change
Previous:From: Simon RiggsDate: 2008-10-31 06:33:02
Subject: Re: BufferAccessStrategy for bulk insert

pgsql-general by date

Next:From: Jodok BatloggDate: 2008-10-31 07:49:07
Subject: tsearch2 problem
Previous:From: Kyle CordesDate: 2008-10-31 04:32:59
Subject: Re: Decreasing WAL size effects

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