Follow
>two days reindexing
fucking postgres needs a better upgrade process than dumping and restoring all the data base
@r how do you add it to the back up tho? I only ran "psql -f" the whole dump
@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
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.