From: | Sohel Tamboli <sohel(dot)tamboli0016(at)gmail(dot)com> |
---|---|
To: | Ron <ronljohnsonjr(at)gmail(dot)com> |
Cc: | pgsql-admin(at)lists(dot)postgresql(dot)org |
Subject: | Re: Upgrade postgresql from 9.1 to 9.6 |
Date: | 2018-07-24 05:06:34 |
Message-ID: | CAAbZosB743pMobmYN3hrd1tpVOfdak-BHG9aZ2LyyMh9Tvmu_g@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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.
Thanks,
Sohel
On 23-Jul-2018 10:53 pm, "Ron" <ronljohnsonjr(at)gmail(dot)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.
From | Date | Subject | |
---|---|---|---|
Next Message | Mariel Cherkassky | 2018-07-24 09:26:34 | Re: pg_authid has duplicated rows |
Previous Message | Andres Freund | 2018-07-23 20:43:19 | Re: pg_authid has duplicated rows |