Re: reindexing db

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.