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
>