On 12/8/20 1:46 AM, Paul Förster wrote:
> 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.
Thisshould get the job done in parallel. :-)
>
> That of course depends on how fast the machine is and how much load it can take. :-)
The purpose of GNU Parallels is to not flood a system. Adding the "--jobs="
feature to reindexdb (along with enumerating tables using "--tables") would
serve the same purpose.
--
Angular momentum makes the world go 'round.