Subject: Re: reindexing db
To: pgsql-admin@lists.postgresql.org
References: <292966DF-135C-4483-81A9-5027FC3C8A82@elevated-dev.com>
 <f477709e-6371-1ba3-84df-37e5df8e5d83@gmail.com>
 <214E5DBC-1F6F-49C1-8B83-9A2EB33E969A@gmail.com>
 <39a8cdb5-bfbb-9ae8-5867-c4234373277c@gmail.com>
 <A54CA469-6EAA-40AD-AD37-7E877268786A@gmail.com>
 <98c19d44-8d4c-f608-5432-eef048965552@gmail.com>
 <01FAC841-0FF0-4B63-A507-C76EFB62A97F@gmail.com>
From: Ron <ronljohnsonjr@gmail.com>
Message-ID: <5cd1d643-b205-57cb-dd80-7054ffb0facc@gmail.com>
Date: Tue, 8 Dec 2020 02:32:37 -0600
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:68.0) Gecko/20100101
 Thunderbird/68.10.0
MIME-Version: 1.0
In-Reply-To: <01FAC841-0FF0-4B63-A507-C76EFB62A97F@gmail.com>
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding: 8bit
Content-Language: en-US
Precedence: bulk

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. 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.