From: | Ron <ronljohnsonjr(at)gmail(dot)com> |
---|---|
To: | pgsql-admin(at)lists(dot)postgresql(dot)org |
Subject: | Re: Upgrade postgresql from 9.1 to 9.6 |
Date: | 2018-07-23 17:23:38 |
Message-ID: | eebf4d33-87bd-8c42-4194-d5df6f61d36b@gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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 | Johannes Truschnigg | 2018-07-23 17:26:52 | Re: Moving the data directory for systemd service startup |
Previous Message | Evan Rempel | 2018-07-23 17:19:31 | Moving the data directory for systemd service startup |