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.
copy | in place | copy||
---|---|---|---|
The amount of disk input-output | > 2x | 2x+ (depends on WAL settings) | |
The amount of required disk space | 2x | limited by WAL settings | 2x |
Data overhead | no | yes(1-2 bytes per page) | no|
Performance(rough estimate) | faster | slower | faster|
Implementation complexity (rough estimate) | |||
Stable topology, read-only | simple | simple | |
Online updates | complex | simple | complex|
Unstable topology | complex | simple | complex
...