≈ the.bay.news

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

Sign in to join the discussion — your thebay.events account works here.

No comments yet.