Hacker News new | ask | show | jobs
by sharadov 2077 days ago
Why not use partitioned tables? Simply drop/archive the child tables that you don't need, and avoid the vacuum overhead.
1 comments
andreypopp 2076 days ago
That’s a different thing. In some cases the whole table needs to be replaced. Then inserts into UNLOGGED tables are still much faster than into regular tables (even if there wasn’t a DELETE before).
link