Re: reindexing db

Ron <ronljohnsonjr@xxxxxxxxx> · Tue, 8 Dec 2020 02:32:37 -0600

On 12/8/20 1:46 AM, Paul Förster wrote:
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. :-)

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.