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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-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
From | Date | Subject | |
---|---|---|---|
Next Message | Jodok Batlogg | 2008-10-31 07:49:07 | tsearch2 problem |
Previous Message | Kyle Cordes | 2008-10-31 04:32:59 | Re: Decreasing WAL size effects |
From | Date | Subject | |
---|---|---|---|
Next Message | Heikki Linnakangas | 2008-10-31 07:40:04 | Re: PG_PAGE_LAYOUT_VERSION 5 - time for change |
Previous Message | Simon Riggs | 2008-10-31 06:33:02 | Re: BufferAccessStrategy for bulk insert |