Hi Ron, > On 08. Dec, 2020, at 08:42, Ron <ronljohnsonjr@xxxxxxxxx> wrote: > > DB=test > while read line; > do > psql $DB "REINDEX TABLE $line CONCURRENTLY;" > done < list_of_tables.txt yes, you can do that of course. In this case, I would add an "&" after the psql and probably a "wait" at the end. This should get the job done in parallel. :-) That of course depends on how fast the machine is and how much load it can take. :-) Cheers, Paul
