Hi Ron,
> On 08. Dec, 2020, at 08:42, Ron <ronljohnsonjr@gmail.com> 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
shouldget the job done in parallel. :-)
That of course depends on how fast the machine is and how much load it can take. :-)
Cheers,
Paul