WAL streming filter is an interesting idea. We can leave full page
backup for local recovery and decrease the amount of WAL to transfer.
If SR writes WAL in record by record basis, implementation will be
simple. If SR writes WAL in block by block basis, WAL records may be
divided from transfer
Thanks a lot for the comment/advice. Yes, full page backup block
considerablly shortens the recovery time. As we discussed about two
years ago, I have a solution accelerate the recovery even without full
page image. I'd like to submit this solution to the community again.
When I evaluated
Tom Lane wrote:
> Bruce Momjian writes:
> > Yes, I would love to get this into /contrib for PG 9.1!
>
> How much are people really going to care about pg_lesslog now that
> we've got streaming replication? There might be some small use-case
> still left, but it's hard to believe that it would
> Until we have a tool to use streaming replication to actually archive
> backups, there's still a fairly large usecase for it...
yes, pglesslog is for PITR. We have a client who keeps 3 days of log
files a time for forensic reasons, and I doubt they're the only one.
--
On Wed, 2010-05-12 at 23:09 +0200, Magnus Hagander wrote:
> On Wed, May 12, 2010 at 11:03 PM, Tom Lane wrote:
> > Bruce Momjian writes:
> >> Yes, I would love to get this into /contrib for PG 9.1!
> >
> > How much are people really going to care about pg_lesslog now that
> > we've got streaming r
On Wed, May 12, 2010 at 11:03 PM, Tom Lane wrote:
> Bruce Momjian writes:
>> Yes, I would love to get this into /contrib for PG 9.1!
>
> How much are people really going to care about pg_lesslog now that
> we've got streaming replication? There might be some small use-case
> still left, but it's
Bruce Momjian writes:
> Yes, I would love to get this into /contrib for PG 9.1!
How much are people really going to care about pg_lesslog now that
we've got streaming replication? There might be some small use-case
still left, but it's hard to believe that it would be worth carrying
it in contri
Koichi Suzuki wrote:
> It is an announcement that long-waited bug-fix of pg_lesslog is now
> released. This includes the following.
>
> 1. Error in calculation of GiST-related WAL record length was fixed.
> 2. pg_compresslog now has an option to print WAL segment analysis.
> 3. New test script i
