pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Ron <ronljohnsonjr@gmail.com>
To: pgsql-admin@lists.postgresql.org
Subject: Re: Upgrade postgresql from 9.1 to 9.6
Date: Mon, 23 Jul 2018 12:23:38 -0500
Message-ID: <eebf4d33-87bd-8c42-4194-d5df6f61d36b@gmail.com> (raw)
In-Reply-To: <CAAbZosDt0e_Wmp-CUZoeRPeuQP+QjOxeWAXMbyMSx9dYNNkmaw@mail.gmail.com>
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>

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.




view thread (4+ messages)  latest in thread

Message-ID: <eebf4d33-87bd-8c42-4194-d5df6f61d36b@gmail.com>
Permalink:  ../eebf4d33-87bd-8c42-4194-d5df6f61d36b@gmail.com/
Also on:    postgresql.org/message-id/eebf4d33-87bd-8c42-4194-d5df6f61d36b@gmail.com

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: ronljohnsonjr@gmail.com, pgsql-admin@lists.postgresql.org
  Subject: Re: Upgrade postgresql from 9.1 to 9.6
  In-Reply-To: <eebf4d33-87bd-8c42-4194-d5df6f61d36b@gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox