@aetios@ak.kawen.space maybe run a full vacuum on it, just in case. and then check your psql config using pgtune, that usually can help to get the most out of the psql cluster