Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qMUvV-002XTh-O7 for pgsql-admin@arkaria.postgresql.org; Thu, 20 Jul 2023 14:46:45 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1qMUvT-009NmM-J7 for pgsql-admin@arkaria.postgresql.org; Thu, 20 Jul 2023 14:46:43 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qMUvT-009Nm9-8I for pgsql-admin@lists.postgresql.org; Thu, 20 Jul 2023 14:46:43 +0000 Received: from mail-wm1-x332.google.com ([2a00:1450:4864:20::332]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1qMUvQ-000WCw-Iu for pgsql-admin@lists.postgresql.org; Thu, 20 Jul 2023 14:46:41 +0000 Received: by mail-wm1-x332.google.com with SMTP id 5b1f17b1804b1-3fbc244d384so7418285e9.0 for ; Thu, 20 Jul 2023 07:46:40 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec-at.20221208.gappssmtp.com; s=20221208; t=1689864399; x=1690469199; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:to:from:subject:message-id:from:to:cc:subject:date :message-id:reply-to; bh=5E/EyO6N+rtI2WPbItg2l9wPox2TQnAwUr3e8FPGxD4=; b=HsEOhXiVG62Wcy26aJymDJAk1BiBC7nPx3mLc5UMdUy36hcw1nL1mMG9YfI3CqoGs+ GRzT7r572vWbgkIr1S17XlxnkdfElgtkJlPH8RL1n0bzWZWxwOINkkIzFhM9nxkeQRDo jChehX4IoKZH8ze2WYuJTp/f/MAZOxhyJiAdluikqcRvSdmxmy78+Hh7XLAM8TrJctz/ 9qSnIMTEodigIQzAIX0BmodTLjGRkbSJrlend2jLeBxo1TNux0olvMutNnMzVfcoj5NJ XgOniTv/g6EPmR/XhlT6fnCKsaw96E3VkA3+epasjY6N6A1kdvXUVC7kSAH0BlzKSXB6 9HNA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20221208; t=1689864399; x=1690469199; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:to:from:subject:message-id:x-gm-message-state:from :to:cc:subject:date:message-id:reply-to; bh=5E/EyO6N+rtI2WPbItg2l9wPox2TQnAwUr3e8FPGxD4=; b=ZGDX6qjznTmImoE/lkPrwHOL1F4frEXU436PYtY71HuwhLSz6CWVRWlYbfjT9uP646 Ppw+FhatBymgINNXywn4AifPyRqyEAiPI3FNSiiM/6ktcfc7sWbQ3wFvAU/dGhJwjd9g PtweyRAYvSxiPdSRbRjWROF9vjqlUiuHQZMrzOQZKu5NMxO1mBXHEY5L1qMWVyWGxCpg muqpcb+tHj8PfCpzgmh+KEo30jnx+XybvWWzaxk+B88+LjJ22JZCrND8lViwnzdkGbci 78FDdKEdoh+N249hwsIHjHB439zq8aZb09eXYJo/nFHrU2nkxfvXI1DF3hAhjCNH8ut4 WZag== X-Gm-Message-State: ABy/qLaSA5FuLJ+uNFOmJAdxkf0HDKb3iqV3mncx+Ei34fQ70Kgn3FF3 84t+YA5j25NNpBaXOS/N5yGt7A== X-Google-Smtp-Source: APBJJlFktlbtdCsGihijMl90wRxfnOTz7JPCQpSQGgQW8NcN5nAJD7sPJ1ibFRhpW1XpYx5uM0avvQ== X-Received: by 2002:a7b:c3cf:0:b0:3fc:f9c:a3e2 with SMTP id t15-20020a7bc3cf000000b003fc0f9ca3e2mr6660663wmj.6.1689864398852; Thu, 20 Jul 2023 07:46:38 -0700 (PDT) Received: from localhost.localdomain ([2001:871:5e:9f9c:795:1a66:3a08:e762]) by smtp.gmail.com with ESMTPSA id q9-20020adff789000000b003142439c7bcsm1543403wrp.80.2023.07.20.07.46.38 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Thu, 20 Jul 2023 07:46:38 -0700 (PDT) Message-ID: Subject: Re: Upgrade from PG12 to PG From: Laurenz Albe To: Jef Mortelle , pgsql-admin@lists.postgresql.org Date: Thu, 20 Jul 2023 16:46:37 +0200 In-Reply-To: References: <3901e0da-819b-5b6d-bb57-c29f6d384725@gmail.com> Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable User-Agent: Evolution 3.46.4 (3.46.4-1.fc37) MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Thu, 2023-07-20 at 15:46 +0200, Jef Mortelle wrote: > So: not possible to have very little downtime if you have a database=20 > with al lot rows containing text=C2=A0 as datatype, as pg_upgrade needs 1= 2hr=20 > for 24 milj rows in pg_largeobject. To clarify: "text" is no problem at all. Large objects are. Yours, Laurenz Albe