senor writes:
> I'm afraid it is 9.2.4.
That's pretty old :-(
> I noticed on 2 installations with similar table numbers (~200,000),
> schema and hardware that one was done in hours and the other didn't
> finish over the weekend. Keeping tabs on pg_stat_activity indicated
> pg_dump was still p
I'm afraid it is 9.2.4. I'm using pg_upgrade from 9.6 and that is using
pg_dump from 9.6.
I noticed on 2 installations with similar table numbers (~200,000),
schema and hardware that one was done in hours and the other didn't
finish over the weekend. Keeping tabs on pg_stat_activity indicated
senor writes:
> I know from a previous post to the community that pg_dump --schema-only is
> single threaded and the --jobs option cannot benefit pg_dump in my case
> (single DB, Single schema, 10+ tables). Using pg_upgrade with the --link
> option is very fast except for the pg_dump portio
I know from a previous post to the community that pg_dump --schema-only is
single threaded and the --jobs option cannot benefit pg_dump in my case (single
DB, Single schema, 10+ tables). Using pg_upgrade with the --link option is
very fast except for the pg_dump portion of the upgrade which
Ron writes:
> On 4/28/19 3:21 PM, senor wrote:
>> 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.
> "pg_dump --schema-only" is single-threaded.
Yup. But ...
pg_upgrade does have a --jobs option, since 9.5 or s
On 4/28/19 3: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
processing with jobs I'm looking for any preparation or configuration
settings that can improve speed.
9.2 to 9
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
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
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 o
