Radim Marek: Getting rid of a 4 TB table in PostgreSQL
boringSQL | Supercharge your SQL & PostgreSQL powers
Radim Marek: Getting rid of a 4 TB table in PostgreSQL
Dropping a large table writes 80 KB of WAL, then stalls replay on every replica while the files are unlinked: 16 s for a cold 1 TB table on ext4, 80 ms on XFS. Plus what batched deletes and copy-and-swap cost when the table still has traffic.
Dropping a large table writes 80 KB of WAL, then stalls replay on every replica while the files are unlinked: 16 s for a cold 1 TB table on ext4, 80 ms on XFS. Plus what batched…
0 comments
No comments yet.