Conversation

Notices

1. Sanae Respecter (frogmaiden@shrine.moe)'s status on Friday, 07-Apr-2023 06:51:08 JST Sanae Respecter

   • pistolero :thispersondoesnotexist:
   Trying to run the psql command 'CREATE INDEX CONCURRENTLY tmp_apid_follower_address ON users USING btree (ap_id, COALESCE(follower_address, ''::character varying));' the FSE blog wrote about but I keep getting ERROR: relation "users" does not exist. What am I doing wrong?
   
   CC: @p
   •  (mint@ryona.agency)'s status on Friday, 07-Apr-2023 06:51:07 JST 

     in reply to

     • pistolero :thispersondoesnotexist:
     @frogmaiden @p Did you select the database beforehand (`\c pleroma`)? But chances are, it won't work to begin with, for me it just got stuck without any noticeable speedups.
   • pistolero :thispersondoesnotexist: (p@freespeechextremist.com)'s status on Friday, 07-Apr-2023 07:12:58 JST pistolero :thispersondoesnotexist:

     in reply to

     • 
     @mint @frogmaiden Depends on the size of the users table, but it was orders of magnitude for me.
      likes this.