From: | Sohel Tamboli <sohel(dot)tamboli0016(at)gmail(dot)com> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | Upgrade postgresql from 9.1 to 9.6 |
Date: | 2018-07-23 17:14:44 |
Message-ID: | CAAbZosDt0e_Wmp-CUZoeRPeuQP+QjOxeWAXMbyMSx9dYNNkmaw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Evan Rempel | 2018-07-23 17:19:31 | Moving the data directory for systemd service startup |
Previous Message | Don Seiler | 2018-07-23 16:07:51 | Streaming Replication Lag and pg_last_xlog_receive_location() question |