>two days reindexing
fucking postgres needs a better upgrade process than dumping and restoring all the data base
@dirb It'd dangerous to index alone! Take this.
CREATE INDEX p_apid_follow_address ON public.users USING btree (ap_id, COALESCE(follower_address, ''));
It'll make the activities_visibility_index creation almost instantaneous.
CREATE INDEX p_apid_follow_address ON public.users USING btree (ap_id, COALESCE(follower_address, ''));
It'll make the activities_visibility_index creation almost instantaneous.
@dirb Run it inside another psql shell. Although, it won't work if you started the restore as a single transaction.
@r it ran, but who knows what is still indexing right now. thanks
