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 1qMkTQ-003BrC-NF for pgsql-admin@arkaria.postgresql.org; Fri, 21 Jul 2023 07:22:48 +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 1qMkTP-00E8Jk-7d for pgsql-admin@arkaria.postgresql.org; Fri, 21 Jul 2023 07:22:47 +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 1qMkTO-00E8JZ-Se for pgsql-admin@lists.postgresql.org; Fri, 21 Jul 2023 07:22:46 +0000 Received: from mail-wm1-x333.google.com ([2a00:1450:4864:20::333]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1qMkTM-000e1M-ET for pgsql-admin@lists.postgresql.org; Fri, 21 Jul 2023 07:22:45 +0000 Received: by mail-wm1-x333.google.com with SMTP id 5b1f17b1804b1-3fbfa811667so16768925e9.1 for ; Fri, 21 Jul 2023 00:22:44 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20221208; t=1689924162; x=1690528962; h=in-reply-to:disposition-notification-to:from:references:cc:to :content-language:subject:user-agent:mime-version:date:message-id :from:to:cc:subject:date:message-id:reply-to; bh=NtaxKd4JfGjL69Cz4SGrNqNv2ZbW9cOIgVTIge+ZB4Y=; b=RFxN+Mr9+Ztv1sEVyDNvamBYaJI1XKU5nPn7wpcad5BxTjn9+iW5NlUeZqywPCJLlT VDMc/wajEzoL6eU/FmhKCUNBImwBUZvEPTLG4Gu3MNRvVs28GR35y8F3u7sWqu4iBIOi nrAxHdoHhirVZu+bwA9/Q5Vd8n/oUmCsxlKf8cERfAtIJQARgS+6Teb1DMqtdd6rdTKN +SC3NGukH2Ik75/uIN4THqmFrhlmmYKKWD2Z7R+9nHn0sJFVo0e8bCe+U0AiKxSHYXRd 0zBPs6lFHmgJ2wkePO6Jd5DeqgVkHrXj1Eyx3xQJri624OrxaVpnLEpp+SItBpx/IINm KaQw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20221208; t=1689924162; x=1690528962; h=in-reply-to:disposition-notification-to:from:references:cc:to :content-language:subject:user-agent:mime-version:date:message-id :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=NtaxKd4JfGjL69Cz4SGrNqNv2ZbW9cOIgVTIge+ZB4Y=; b=Lm3+y9zeVfsEOoPMkUd3MU4de79wSLHeLVTan9QnSU4iLg3ifFVmmtwCTal1hUMguF QYAtVYDBEgx6xK25d6M72aJeFng0tPseLizjS+CAym/ZIXTTGs879SQrlVKYFPltQ/wA PIJHhOuvh8xizxSbm9LYEyVJ3lAoL4o4I96V+uSDjthVq/X0QYCw4Lhd3bjYKZ4KEAoE yC5Ihh9IoEOSKIKK8kNTvvrvsLGrL02ovm5y3LqwdAELXFfkhTeXK3AaBYne6n2LzO2i 2NdFDU+J0Q3wOm+KZdTM8fyNdlbevfVGY0lFwhGFiC2EwlB0hwICdqEig48DeCcyuCW4 GFpQ== X-Gm-Message-State: ABy/qLY4JlqWshMJ/2iGOC34700mm50PhenpsEqlXA07Zcw3T1zMYMqb WSDo8TZoYUDe/tFtcNj71VMnlPah+Q4= X-Google-Smtp-Source: APBJJlFLw7l1MdlL8ZqeCOuV6nfdf+tEHHDIM+uhwO1HwSaOnBEfR7/+4N9R6vrMTeivlnDPnmQrOg== X-Received: by 2002:a7b:ca47:0:b0:3fb:416d:7324 with SMTP id m7-20020a7bca47000000b003fb416d7324mr973874wml.6.1689924161851; Fri, 21 Jul 2023 00:22:41 -0700 (PDT) Received: from [10.1.1.193] (94-224-49-27.access.telenet.be. [94.224.49.27]) by smtp.gmail.com with ESMTPSA id bh17-20020a05600c3d1100b003fbb1ce274fsm15761496wmb.0.2023.07.21.00.22.41 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Fri, 21 Jul 2023 00:22:41 -0700 (PDT) Content-Type: multipart/alternative; boundary="------------vdrP7xD0yXSa1fgg00DiSB0E" Message-ID: Date: Fri, 21 Jul 2023 09:22:39 +0200 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: Upgrade from PG12 to PG Content-Language: nl, en-US, fr To: Scott Ribe Cc: pgsql-admin@lists.postgresql.org References: <3901e0da-819b-5b6d-bb57-c29f6d384725@gmail.com> From: Jef Mortelle Disposition-Notification-To: Jef Mortelle In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk This is a multi-part message in MIME format. --------------vdrP7xD0yXSa1fgg00DiSB0E Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit On 20/07/2023 16:51, Scott Ribe wrote: >> Alsready tried to use --link and --jobs, but you cannot ommit the "select lo_unlink ...." for every rows containing datatype text in your database that the pg_* program creates in the export/dump file. > Terminology again, or are you conflating two different issues? pg_upgrade --link does not create a dump file. why does pg_dump/pg_restore for every row in pg_largeobject a "select lo_unlink ...." this takes a lot of time --------------vdrP7xD0yXSa1fgg00DiSB0E Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: 8bit


On 20/07/2023 16:51, Scott Ribe wrote:
Alsready tried to use --link and --jobs, but you cannot ommit the "select  lo_unlink ...."   for every rows containing datatype text in your database that the pg_* program creates in the export/dump file.

Terminology again, or are you conflating two different issues? pg_upgrade --link does not create a dump file.

why does pg_dump/pg_restore for every row in pg_largeobject a   "select lo_unlink ...." this takes a lot of time

--------------vdrP7xD0yXSa1fgg00DiSB0E--