1) I always wonder of there is a better way than COPY. I tend to quickly get 100% CPU without saturating I/O
2) The row overhead seems big. A row has 23 bytes overhead, this table has 48 bytes data per row, so even without page overhead, we lose ~1/3 of our storage. This is pure data storage, without any index.
1) I always wonder of there is a better way than COPY. I tend to quickly get 100% CPU without saturating I/O
2) The row overhead seems big. A row has 23 bytes overhead, this table has 48 bytes data per row, so even without page overhead, we lose ~1/3 of our storage. This is pure data storage, without any index.