On Tue, Jul 24, 2018 at 10:36:34AM +0530, Sohel Tamboli wrote: > Hi Ron, > > Thanks!! > I tried to grep all the process owned by postgres as well, but got same > results. No other process are active other than two threads of pg_upgrade. pg_upgrade can only parallelize a few things --- from the docs: The <option>--jobs</option> option allows multiple CPU cores to be used for copying/linking of files and to dump and reload database schemas in parallel; My guess is that there were not more than two things that could be parallelized. --------------------------------------------------------------------------- > > Thanks, > Sohel > > On 23-Jul-2018 10:53 pm, "Ron" <ronljohnsonjr@xxxxxxxxx> wrote: > > I'd grep for all processes owned by postgres, since the pg_upgrade > processes probably spawn children. > > > On 07/23/2018 12:14 PM, Sohel Tamboli wrote: > > Hi, > > I am trying to upgrade my postgresql database from version 9.1 to 9.6 > using pg_upgrade utility. > I have started this activity with 6 threads and running with no issues > but I can see only 2 active threads of pg_upgrade when checked on OS > using "ps -ef| grep pg_upgrade" which might slow down my upgrade > process. > Is there any limit of adding jobs in "-j" parameter in pg_upgrade > utility? > Or is there any settings that I need to configure in postgresql.conf > file? > > Below are the configuration of my server: > OS : Amazon Linux > RAM: 64GB > CPU: 16 > DB size : 5 TB > Upgrade utility : pg_upgrade > Jobs: 6 > Issue : only 2 threads of pg_upgrade are active > > Appreciate your help!! > > Thanks, > Sohel > > > -- > Angular momentum makes the world go 'round. > > > -- Bruce Momjian <bruce@xxxxxxxxxx> http://momjian.us EnterpriseDB http://enterprisedb.com + As you are, so once was I. As I am, so you will be. + + Ancient Roman grave inscription +
