@mint @7666 @shitpisscum @shitpisscum @Economic_Hitman Over two years; select count(1) from activities; count ---------- 53683089 (1 row) Postgres connections can be tuned to have larger caches. https://pgtune.leopard.in.ua/ can give reasonable defaults. In practice, you may want to have cache sizes as big as available memory allows, and limit total number of workers accordingly. And naturally, the most recent part of tables is preferably to be located on nvme SSD.