... | ... | @@ -70,6 +70,20 @@ DROP SERVER cstore_server; |
|
|
DROP EXTENSION cstore_fdw;
|
|
|
```
|
|
|
|
|
|
## Effect of compression block size (for random access)
|
|
|
|
|
|
Tested on acuma 18M PCAP file.
|
|
|
|
|
|
| Block size | LZ4 -9 | XZ -6 |
|
|
|
| --- | --- | --- |
|
|
|
| 64kB | 40.5% | 34.5% |
|
|
|
| 256kB | 36.5% | 28.4% |
|
|
|
| 1MB | 35.4% | 23.6% |
|
|
|
| 4MB | 35.2% | 19.9% |
|
|
|
| full file | N/A | 17.0% |
|
|
|
|
|
|
Note: "block dependency" (`-BD`) only gets 0.1% improvement for XZ -9 -B7.
|
|
|
|
|
|
|
|
|
## DNS volume estimates (older)
|
|
|
|
... | ... | |