Re: Decreasing WAL size effects

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Greg Smith <gsmith(at)gregsmith(dot)com>
Cc: 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-30 22:40:10
Message-ID: 28319.1225406410@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

Greg Smith <gsmith(at)gregsmith(dot)com> writes:
> 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.

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. Putting functionality like that into
core is infinitely more interesting than putting band-aids on a
segmented approach.

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2008-10-30 22:41:51 Re: Are there plans to add data compression feature to postgresql?
Previous Message Scott Marlowe 2008-10-30 22:35:38 Re: Are there plans to add data compression feature to postgresql?

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2008-10-30 22:49:38 Re: User defined I/O conversion casts
Previous Message Greg Smith 2008-10-30 22:23:03 Re: Decreasing WAL size effects