pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedUpgrade postgresql from 9.1 to 9.6
4+ messages / 3 participants
[nested] [flat]
* Upgrade postgresql from 9.1 to 9.6
@ 2018-07-23 17:14 Sohel Tamboli <sohel.tamboli0016@gmail.com>
0 siblings, 1 reply; 4+ messages in thread
From: Sohel Tamboli @ 2018-07-23 17:14 UTC (permalink / raw)
To: 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
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Upgrade postgresql from 9.1 to 9.6
@ 2018-07-23 17:23 Ron <ronljohnsonjr@gmail.com>
parent: Sohel Tamboli <sohel.tamboli0016@gmail.com>
0 siblings, 1 reply; 4+ messages in thread
From: Ron @ 2018-07-23 17:23 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
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.
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Upgrade postgresql from 9.1 to 9.6
@ 2018-07-24 05:06 Sohel Tamboli <sohel.tamboli0016@gmail.com>
parent: Ron <ronljohnsonjr@gmail.com>
0 siblings, 1 reply; 4+ messages in thread
From: Sohel Tamboli @ 2018-07-24 05:06 UTC (permalink / raw)
To: Ron <ronljohnsonjr@gmail.com>; +Cc: pgsql-admin@lists.postgresql.org
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@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.
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Upgrade postgresql from 9.1 to 9.6
@ 2018-08-10 19:02 Bruce Momjian <bruce@momjian.us>
parent: Sohel Tamboli <sohel.tamboli0016@gmail.com>
0 siblings, 0 replies; 4+ messages in thread
From: Bruce Momjian @ 2018-08-10 19:02 UTC (permalink / raw)
To: Sohel Tamboli <sohel.tamboli0016@gmail.com>; +Cc: Ron <ronljohnsonjr@gmail.com>; pgsql-admin@lists.postgresql.org
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 +
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2018-08-10 19:02 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2018-07-23 17:14 Upgrade postgresql from 9.1 to 9.6 Sohel Tamboli <sohel.tamboli0016@gmail.com>
2018-07-23 17:23 ` Ron <ronljohnsonjr@gmail.com>
2018-07-24 05:06 ` Sohel Tamboli <sohel.tamboli0016@gmail.com>
2018-08-10 19:02 ` Bruce Momjian <bruce@momjian.us>
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