Re: [FEATURE REQUEST] Streaming Onlinebackup (Maybe OFFTOPIC)

From: "Florian G(dot) Pflug" <fgp(at)phlo(dot)org>
To: Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov>
Cc: Simon Riggs <simon(at)2ndquadrant(dot)com>, Jeff Davis <pgsql(at)j-davis(dot)com>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: [FEATURE REQUEST] Streaming Onlinebackup (Maybe OFFTOPIC)
Date: 2007-09-27 00:29:17
Message-ID: 46FAF95D.6070003@phlo.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Kevin Grittner wrote:
> I omitted the code I was originally considering to have it work against
> files "in place" rather than as a filter. It seemed much simpler this
> way, we didn't actually have a use case for the additional functionality,
> and it seemed safer as a filter. Thoughts?

A special "non-filter" mode could save some IO and diskspace by not actually
writing all those zeros, but instead just seek to SizeOfWal-1 after writing the
last valid byte, and writing one more zero. Of course, if you're gonna
compress the WAL anyway, there is no point...

greetings, Florian Pflug

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Zdenek Kotala 2007-09-27 02:13:17 Re: top for postgresql (ptop?)
Previous Message Tom Lane 2007-09-26 23:33:03 Re: [HACKERS] Document and/or remove unreachable code in tuptoaster.c from varvarlena patch