I would like to know why the database seems frozen.> ...
The problem happened at 04:15 AM during a vacuum FULL and could occurs at every moment
VACUUM FULL locks your tables.
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
