undefined | Better HN

0 pointssharadov5y ago0 comments

Why not use partitioned tables? Simply drop/archive the child tables that you don't need, and avoid the vacuum overhead.

0 comments

andreypopp5y 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).

j / k navigate · click thread line to collapse

0 pointssharadov5y ago0 comments

Why not use partitioned tables? Simply drop/archive the child tables that you don't need, and avoid the vacuum overhead.

0 comments

andreypopp5y 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).

j / k navigate · click thread line to collapse