4 ms·
There are so many unfortunate footguns with unlogged tables, that I'd argue that the goroutine route is preferable.
by nemothekid 5mo ago
There are so many unfortunate footguns with unlogged tables, that I'd argue that the goroutine route is preferable.
- jeltz 5mo agoSuch as?
- petcat 5mo agoWhat are the "footguns" with unlogged tables in Postgres?
- nemothekid 5mo ago1. If postgres shutsdowns uncleanly, your entire table is truncated; you lose everything. 2. You should check if your backup method backs up unlogged tables. For example, RDS Snapshots on AWS do not backup unlogged tables. These 2 are a double whammy where if you aren't aware of these tradeoffs you can find that a bad restart has deleted all your data, plus your unlogged tables were never backed up.