[Spike] Investigate WAL per Database solution

Description

Investigate WAL per Database solution

How to document

None

How to test

None

Activity

Show:

andrew.pogrebnoi February 10, 2025 at 2:03 PM

There is a way to encrypt individual records that related to some relation as every WAL record w/ data that has to flushed to the disk contains backup block which in turn contains RelfileLocator. But this would be potentially costly enterprise. Anyway I think it doesn’t make sense to go for it now. We can implement it later on (on top of current solution) if there will be such a demand. I see two option for the implementation:

  1. Encrypt records while inserting them into WAL. That is more local way to do this but requires additional core changes.

  2. Split the WAL’s byte stream into records and processing them while writing/reading it to/from disk. A bit clumsy but no need in additional core changes

Done

Details

Assignee

Reporter

Labels

Priority

Smart Checklist

Created December 17, 2024 at 10:48 AM
Updated last week
Resolved February 10, 2025 at 2:04 PM

Flag notifications