@15066d8d @b17a3b4f @67975218 @jaf Yes, full vacuum is slow and explicite locks the table while it's working on it, meaning for example, can't record new notes in the database. So be careful with that. 

 @9046526e Whenever I run VACUUM ANALYZE and pg_dump I stop Misskey so that no activity is taking place while PostgreSQL does it's things. @15066d8d @67975218 @jaf 

 @b17a3b4f @9046526e @15066d8d @jaf i leave misskey on for pg_dump with no issues 

 @67975218 It's probably fine, I'm just trying to be very cautious. Not like I have hundreds of users upset if there is downtime anyway. @9046526e @15066d8d @jaf 

 @b17a3b4f @67975218 @15066d8d @jaf @9046526e Use pg repack,  its like vacuum but your db stays online l.