Re: Faster way of upgrading postgresql to 10 from 9.5

What profiling will help in this case? Sent from GMail on Android On Nov 25, 2017 8:49 PM, "Tom Lane" wrote: > Debraj Manna 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 >