THIS IS A TEST INSTANCE. ALL YOUR CHANGES WILL BE LOST!!!!
...
This strategy requires changing the format of the encryption page to store the identifier (number) of the encryption key. Each encrypted page has a space reserved for a page crc (4 bytes) that has an encryption block size (minimum 8 bytes).
copy | in place | |
---|---|---|
The amount of disk input-output | 2x | 2x+ (depends on WAL settings) |
The amount of required disk space | 2x | limited by WAL settings |
Performance(rough estimate) | faster | slower |
Implementation complexity (rough estimate) | ||
Stable topology, read-only | simple | simple |
Online updates | complex | simple |
Unstable topology | complex | simple |
...