Re: reindexing db

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