Re: Faster way of upgrading postgresql to 10 from 9.5

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



What profiling will help in this case?

Sent from GMail on Android

On Nov 25, 2017 8:49 PM, "Tom Lane" <tgl@xxxxxxxxxxxxx> wrote:
Debraj Manna <subharaj.manna@xxxxxxxxx> writes:
> Is this time expected? I mean 17 minutes for 490 GB. I could not find any
> benchmark for pg_upgrade.

It seems awfully slow, if you're using -k.  That switch should remove any
dependency on the data size, but what remains is the number of SQL objects
(databases, tables, functions, etc).  If you've got tens or hundreds of
thousands of those, maybe this would be a reasonable time.

As Alvaro said, it's possible that you're hitting some fixable bottleneck;
but to identify what that is we'd need some profiling information.

                        regards, tom lane

[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux