| 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 |