Simon Riggs wrote:
On Thu, 2009-01-22 at 16:15 +0200, Heikki Linnakangas wrote:
That might be useful. But again, could just as well be implemented as an external tool like pglesslog.

There is no WAL record for "no-op", at least not one of variable length.

Hmm, maybe there should be? That seems like a useful thing to have for external tools.

The WAL files can't just have chunks of zeroes in the middle of them,
they must be CRC valid and chained together in the exact byte position.
There isn't any way to do this, even if there were, that's a seriously
complex way of doing that.

Hmm, I think you could remove the records in the middle, rechain the remaining ones, recalculate the crc, and put an xlog switch record at the end. I agree that's seriously complicated, a no-op record would be much simpler.

--
  Heikki Linnakangas
  EnterpriseDB   http://www.enterprisedb.com

--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

Reply via email to