pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Bruce Momjian <bruce@momjian.us>
To: Sohel Tamboli <sohel.tamboli0016@gmail.com>
Cc: Ron <ronljohnsonjr@gmail.com>
Cc: pgsql-admin@lists.postgresql.org
Subject: Re: Upgrade postgresql from 9.1 to 9.6
Date: Fri, 10 Aug 2018 15:02:45 -0400
Message-ID: <20180810190245.GB7840@momjian.us> (raw)
In-Reply-To: <CAAbZosB743pMobmYN3hrd1tpVOfdak-BHG9aZ2LyyMh9Tvmu_g@mail.gmail.com>
References: <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>
	<eebf4d33-87bd-8c42-4194-d5df6f61d36b@gmail.com>
	<CAAbZosB743pMobmYN3hrd1tpVOfdak-BHG9aZ2LyyMh9Tvmu_g@mail.gmail.com>

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@gmail.com> 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@momjian.us>        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 +




view thread (4+ messages)

Message-ID: <20180810190245.GB7840@momjian.us>
Permalink:  ../20180810190245.GB7840@momjian.us/
Also on:    postgresql.org/message-id/20180810190245.GB7840@momjian.us

 · 

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 from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: bruce@momjian.us, sohel.tamboli0016@gmail.com, ronljohnsonjr@gmail.com
  Subject: Re: Upgrade postgresql from 9.1 to 9.6
  In-Reply-To: <20180810190245.GB7840@momjian.us>
  References: <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> <eebf4d33-87bd-8c42-4194-d5df6f61d36b@gmail.com> <CAAbZosB743pMobmYN3hrd1tpVOfdak-BHG9aZ2LyyMh9Tvmu_g@mail.gmail.com> <20180810190245.GB7840@momjian.us>

* 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