THIS IS A TEST INSTANCE. ALL YOUR CHANGES WILL BE LOST!!!!
...
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 |
Data overhead | no | yes(1-2 bytes per page) |
Performance(rough estimate) | faster | slower |
Implementation complexity (rough estimate) | ||
Stable topology, read-only | simple | simple |
Online updates | complex | simple |
Unstable topology | complex | simple |
...