Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1q5FNP-0005LY-0B for pgsql-general@arkaria.postgresql.org; Sat, 03 Jun 2023 00:44:15 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1q5FNM-0005TR-IH for pgsql-general@arkaria.postgresql.org; Sat, 03 Jun 2023 00:44:12 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1q5FNM-0005TI-7b for pgsql-general@lists.postgresql.org; Sat, 03 Jun 2023 00:44:12 +0000 Received: from mail-yb1-xb2e.google.com ([2607:f8b0:4864:20::b2e]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1q5FNJ-003nMb-7L for pgsql-general@postgresql.org; Sat, 03 Jun 2023 00:44:11 +0000 Received: by mail-yb1-xb2e.google.com with SMTP id 3f1490d57ef6-bacf9edc87bso2800825276.1 for ; Fri, 02 Jun 2023 17:44:09 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20221208; t=1685753048; x=1688345048; h=content-transfer-encoding:subject:from:content-language:to :user-agent:mime-version:date:message-id:from:to:cc:subject:date :message-id:reply-to; bh=sDVLRD6lU0AVIr5m1WL6IsBeqX+bJQnChgc8LUNE4hE=; b=WOmTogTI6GpbLGcpbKXiUUL7xBWQ3AzluIKtOFyzyG/gFciydZ1lIQnbpBA7/r1wYf iT724gEQYEpiSWf1l8rJZt2wC66PFj73HjhNj29+Zy76MWQuj7ZQ8xiwSPT1gpiNWRPc NKcWxUXUSZwpycgSAg5lTT2IIDG719SSRZcZF43sMDQ1Q8Eiw4GUDtpPfRrWjd6U9KJ0 k/GbmZ8fxjWceNO+LdEdj1nSFvmhXpzXbe7VTqOzzWChUDWDlXiXw+K+RDZl3H+4BO90 c10j50NlNoZdgxA3MpIQhDINDE0neqwg7N/faf5T22W1//1UpvmzNtziydwgccrFyAK9 dnUA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20221208; t=1685753048; x=1688345048; h=content-transfer-encoding:subject:from:content-language:to :user-agent:mime-version:date:message-id:x-gm-message-state:from:to :cc:subject:date:message-id:reply-to; bh=sDVLRD6lU0AVIr5m1WL6IsBeqX+bJQnChgc8LUNE4hE=; b=USB0ZicF3EBg8illRJnsKghYFhK3uvN6fFUIrnw4iOMRsz6tPlF8J7xmYBMqxO1VDk RB5l+j5RfrWcFeR0zgdg9v9pTdwDm/v9HQ/HheP9ddlC0bUk3g1tUeAMlq54exkcd7rY uIOW1SrbnhdJ2/zxgb4aNPO7h4baXOv2g5LUzM79x0g8jd9AkaacpYZrXmrIGGLz3bAw bcHwQ1ssgRpSUxT3SuoNGmCdx6hJhn7jNgV/+Iu7r1DkkosJ9Sid+/JBuxAiKOJXunjO /0hH1xBHnDdcEsQ7MF44A66flhfif+K7sqJliQNXsuhMS8OWpbNebNCILAg1VKF+InIe D5rA== X-Gm-Message-State: AC+VfDwGwEBE1rPhA7Jngv22po+SrEGH/WrmBzz7aEdanx70yZl7gmos YvYMFgoI69OCZAPTcC4hCq1ADqpRHdo= X-Google-Smtp-Source: ACHHUZ7fTEkZd+Pp/7Q5ku7sIV2W+c9Yb2gPQRjWXZgzEbwerN6ocpRdjEPXaY2kmH5P6bpPNxowSg== X-Received: by 2002:a25:ac51:0:b0:ba1:66fa:ad35 with SMTP id r17-20020a25ac51000000b00ba166faad35mr4980940ybd.53.1685753047838; Fri, 02 Jun 2023 17:44:07 -0700 (PDT) Received: from ?IPV6:2600:1700:bd2c:b810:d816:fcbf:df7e:7054? ([2600:1700:bd2c:b810:d816:fcbf:df7e:7054]) by smtp.googlemail.com with ESMTPSA id b64-20020a253443000000b00bb0cb0fe17csm748654yba.41.2023.06.02.17.44.07 for (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Fri, 02 Jun 2023 17:44:07 -0700 (PDT) Message-ID: <6185dd27-b3d3-b594-33fc-58345df79a13@gmail.com> Date: Fri, 2 Jun 2023 19:44:07 -0500 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:102.0) Gecko/20100101 Thunderbird/102.10.0 To: pgsql-general Content-Language: en-US From: Ron Subject: pg_upgrade and schema complexity... Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Ran into this when upgrading from 13.11 to 15.3... The pg_restore phase failed with "ERROR: out of shared memory", and recommended that I increase max_locks_per_transaction.  Doing so let the process run to completion. It took 12.5 minutes to upgrade a 13GB instance.  Soon after, I upgraded a 78GB cluster, and it only took 3.1 minutes. (Both are VMs (same number of CPUs and RAM) connected to the same SAN.) A "pg_dump --schema-only" of the two systems shows that the small-but-slow schema is 5.9M lines. Is this to be expected of such a huge schema? -- Born in Arizona, moved to Babylonia.