3 ms·
Why not use partitioned tables? Simply drop/archive the child tables that you don't need, and avoid the vacuum overhead.
by sharadov 6y ago
Why not use partitioned tables? Simply drop/archive the child tables that you don't need, and avoid the vacuum overhead.
- andreypopp 6y agoThat’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).