Subject: Re: Upgrade postgresql from 9.1 to 9.6
To: pgsql-admin@lists.postgresql.org
References: 
 <CAAbZosCZRVU_s__y57JDJhD8COxeN_rHHR6fqTOrNeA_vCB_Kw@mail.gmail.com>
 <CAAbZosC+ju6pNox+9StadJivJx0__+xhC6LTyqQf1S347DMxwg@mail.gmail.com>
 <CAAbZosAHkG+C9z0pV1O=3orY52w7jB4iqGURccyk+_e_odA-vw@mail.gmail.com>
 <CAAbZosAuq6xrqfNFS4t+8x5vUjmt9apULaov3zPKO4UGLvy_8w@mail.gmail.com>
 <CAAbZosDbPYJw0UOQmwUi=bOoxjz=cste60TrcUXyUqqrBXdFcQ@mail.gmail.com>
 <CAAbZosB+oRk9AL_Yg-RSAQuSdr--24eX0mQwUMqTAvgZM9KknQ@mail.gmail.com>
 <CAAbZosAhRPeoAAtHcaxytbja=u9rWymA8mU9_E0A453ayNOCgw@mail.gmail.com>
 <CAAbZosCOQEWktwM6ZjA0tFedvKEmTDNHFaZG1=SbVP4oyOrq3g@mail.gmail.com>
 <CAAbZosCe1c+FXATDPkd7eFs3sC-zFVfC+CXNWPLvrF23MeT_nQ@mail.gmail.com>
 <CAAbZosDVnjjceMjvsi0R-MjvTGU0axvLd-TNzjv-VNW_nnEcig@mail.gmail.com>
 <CAAbZosBwBKgka+WuBDNJZ3c1dFz8upyGtvOwh0fJH=Ybm9VhWw@mail.gmail.com>
 <CAAbZosAyGZuTQgY87b-akLf-+npYmW4OTRsZt8pedZ3cgV_uHA@mail.gmail.com>
 <CAAbZosBLM_U9e_5B-re5RRzZgbj9ZMiHdPb6A2VTab+c5fpoWw@mail.gmail.com>
 <CAAbZosDt0e_Wmp-CUZoeRPeuQP+QjOxeWAXMbyMSx9dYNNkmaw@mail.gmail.com>
From: Ron <ronljohnsonjr@gmail.com>
Message-ID: <eebf4d33-87bd-8c42-4194-d5df6f61d36b@gmail.com>
Date: Mon, 23 Jul 2018 12:23:38 -0500
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:52.0) Gecko/20100101
 Thunderbird/52.9.1
MIME-Version: 1.0
In-Reply-To: 
 <CAAbZosDt0e_Wmp-CUZoeRPeuQP+QjOxeWAXMbyMSx9dYNNkmaw@mail.gmail.com>
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding: 8bit
Content-Language: en-US
Precedence: bulk

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.