From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
---|---|
To: | senor <frio_cervesa(at)hotmail(dot)com>, "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
Subject: | Re: Optimize pg_dump schema-only |
Date: | 2019-04-28 20:48:42 |
Message-ID: | 997e18e9-c659-1249-f7f8-5a9ee8c4d4a9@aklaver.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 4/28/19 1:21 PM, senor wrote:
> Hi All,
>
> I'm looking for advice for optimizing the pg_dump portion of "pg_upgrade
> --link". Since this schema only dump can't take advantage of parallel
The above is going to need more explanation or a command line example.
> processing with jobs I'm looking for any preparation or configuration
> settings that can improve speed.
>
> 9.2 to 9.6
> CentOS 6/64bit
> 512GB
>
> I see only one CPU of 32 doing anything and it's often at 100%. Disk IO
> is minimal. Memory use varies but always plenty to spare.
>
> During upgrade I'm running:
> Only the upgrade - no other services
> work_mem = 50MB
> maintenance_work_mem = 2048MB
> shared_buffers = 30GB
> max_locks_per_transaction = 4096
> autovacuum = off
> autovacuum_freeze_max_age = 1500000000 #Had previous issues with
> vacuum (to prevent wrap)
>
> Truthfully, I thought I had increased work_mem until starting this
> email. But increasing it is just a guess unless I get advice to do so
> here. I'm at a knowledge level where I can only guess at the relevance
> of vacuum, analyze or any other preparatory actions I can complete
> before taking postgres offline for upgrade. My feeling is that the
> bottleneck is the backend and not pg_dump. School me on that if needed
> please.
>
> Any advice and explanation is appreciated.
>
> - Senor
>
--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Ron | 2019-04-28 21:08:41 | Re: Optimize pg_dump schema-only |
Previous Message | senor | 2019-04-28 20:21:40 | Optimize pg_dump schema-only |