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 <pgsql-admin-owner+archive@lists.postgresql.org>)
	id 1qMUxs-002XZN-VK
	for pgsql-admin@arkaria.postgresql.org; Thu, 20 Jul 2023 14:49:12 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.94.2)
	(envelope-from <pgsql-admin-owner+archive@lists.postgresql.org>)
	id 1qMUxr-009Ucz-Dc
	for pgsql-admin@arkaria.postgresql.org; Thu, 20 Jul 2023 14:49:11 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
	by malur.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <jefmortelle@gmail.com>)
	id 1qMUxr-009Ucr-2q
	for pgsql-admin@lists.postgresql.org; Thu, 20 Jul 2023 14:49:11 +0000
Received: from mail-wr1-x42a.google.com ([2a00:1450:4864:20::42a])
	by magus.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256
	(Exim 4.94.2)
	(envelope-from <jefmortelle@gmail.com>)
	id 1qMUxn-000fP3-Rw
	for pgsql-admin@lists.postgresql.org; Thu, 20 Jul 2023 14:49:10 +0000
Received: by mail-wr1-x42a.google.com with SMTP id
 ffacd0b85a97d-314417861b9so681964f8f.0
        for <pgsql-admin@lists.postgresql.org>;
 Thu, 20 Jul 2023 07:49:08 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=gmail.com; s=20221208; t=1689864548; x=1690469348;
        h=in-reply-to:disposition-notification-to:from:references:to
         :content-language:subject:user-agent:mime-version:date:message-id
         :from:to:cc:subject:date:message-id:reply-to;
        bh=erb6rb+03rZ32l2Iz9Dtu3tTp86tgEXYupb9y5K6pNo=;
        b=PL2HPZge8JsDxOFU2yc1WAcxE/Zt4vc6nHJEP30aSXXndvNC4jtk9YnQbWewYK6Fce
         qHzP9vYugGcvXOiHVx0TOI0uLxX9PiST5Q1F9SY+Lv/4tcKQVwqyGMKBO1S9kyhfv8kq
         njg3p5XNVgwNFkYHUjKPTG25XSzA4O1uQBQ/e7pKWFXkPHqbG4St9rPbK2eyN6jzfbBL
         MqnTF/Xt1oQzkf7MR5g2TRFWnzyXDWuAHBedQOKwCl3PhL+vdraUiBCN/PSR694Dzt4u
         nVOidW0Ld+TMOq7JYygL95X+dWxn9TYa/LfctTGmVGBepCJBk1RQLGXWVlTN9uDKvEcC
         cf/g==
X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=1e100.net; s=20221208; t=1689864548; x=1690469348;
        h=in-reply-to:disposition-notification-to:from:references: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=erb6rb+03rZ32l2Iz9Dtu3tTp86tgEXYupb9y5K6pNo=;
        b=TkMzUW3jNiSJvYzybzMhXpv53VueIrYlaYrCD9R7mCnYNxRrGVzQd2U7GbwMfvYigN
         bi+SSNdBDllO9l+5F5evSUPj6R2GHETt/HbpW8kL/VRn5pOWdRt7I2NeLiJL1Cz9a4HZ
         iWdoKQoyQel9HwJJkJuPRyIsTh5YRGP9hpV7JEIXVd3n6pmGhy2JtKXp+wmw8ZQj+wXo
         YpTk3nU1iKTOU2ndd7iZKEbZs0r5Ij88Ry4gn0BTN3jHY/IKtXgFkZSlmb31AEAVStKU
         BJQTwzanUqiihvXMns36KBl7h1KHtEuHYjSORelt2mu23QCAZxdfoXRVfDbcCGHC5Zd4
         K1Ag==
X-Gm-Message-State: ABy/qLZQfSOTdH+a2d51BSXNo/5jAe5q2zhjJ9MAEGW65lfQ1wpJp6va
	Tc0UCA/qxJ1p5uszN1zUgLXTFntVyC8=
X-Google-Smtp-Source: 
 APBJJlHJJoiz23gPUcA6uapmZtxSiVeEZLmtqp7I8wCSOLWdW1rykSLlkXaC6Z8G3yW5npOPeH9lOQ==
X-Received: by 2002:a5d:5252:0:b0:314:15b7:20a5 with SMTP id
 k18-20020a5d5252000000b0031415b720a5mr2299900wrc.54.1689864547713;
        Thu, 20 Jul 2023 07:49:07 -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
 c16-20020adfe750000000b0030fb828511csm1546698wrn.100.2023.07.20.07.49.07
        (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128);
        Thu, 20 Jul 2023 07:49:07 -0700 (PDT)
Content-Type: multipart/alternative;
 boundary="------------JoSw52iLBflAe7XUs0Hinm8J"
Message-ID: <b5fa55f1-7f6b-5e10-a3d5-52436ee47738@gmail.com>
Date: Thu, 20 Jul 2023 16:49:05 +0200
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
Subject: Re: Upgrade from PG12 to PG
Content-Language: nl, en-US, fr
To: Laurenz Albe <laurenz.albe@cybertec.at>, pgsql-admin@lists.postgresql.org
References: <3901e0da-819b-5b6d-bb57-c29f6d384725@gmail.com>
 <CAG95seWz3dJxKQPg4_3EAEBCXUuJTDpZBUKAp0+bqP2amQaZ9g@mail.gmail.com>
 <dc88d14d-6d0f-2d67-ecfc-c7495bf1c22b@gmail.com>
 <a0a7dceb61ab4ae3b2178566684fd3bdf087e698.camel@cybertec.at>
From: Jef Mortelle <jefmortelle@gmail.com>
Disposition-Notification-To: Jef Mortelle <jefmortelle@gmail.com>
In-Reply-To: <a0a7dceb61ab4ae3b2178566684fd3bdf087e698.camel@cybertec.at>
List-Id: <pgsql-admin.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-admin@lists.postgresql.org>
List-Owner: <mailto:pgsql-admin-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-admin>
Archived-At: 
 <https://www.postgresql.org/message-id/b5fa55f1-7f6b-5e10-a3d5-52436ee47738%40gmail.com>
Precedence: bulk

This is a multi-part message in MIME format.
--------------JoSw52iLBflAe7XUs0Hinm8J
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit

Yes,
But create text allows you to store more data,


    8.3. Character Types

*Table 8.4. Character Types*

Name 	Description
|character varying(/|n|/)|, |varchar(/|n|/)| 	variable-length with limit
|character(/|n|/)|, |char(/|n|/)| 	fixed-length, blank padded
|text| 	variable unlimited length

On 20/07/2023 16:46, Laurenz Albe wrote:
> 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
>> with al lot rows containing text  as datatype, as pg_upgrade needs 12hr
>> for 24 milj rows in pg_largeobject.
> To clarify: "text" is no problem at all.  Large objects are.
>
> Yours,
> Laurenz Albe
--------------JoSw52iLBflAe7XUs0Hinm8J
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 8bit

<!DOCTYPE html>
<html>
  <head>
    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
  </head>
  <body>
    <p>Yes,<br>
      But create text allows you to store more data, <br>
    </p>
    <p><br>
    </p>
    <div class="titlepage">
      <div>
        <div>
          <h2 class="title" style="clear: both">8.3. Character Types</h2>
        </div>
      </div>
    </div>
    <a id="id-1.5.7.11.2" class="indexterm" name="id-1.5.7.11.2"></a><a
      id="id-1.5.7.11.3" class="indexterm" name="id-1.5.7.11.3"></a><a
      id="id-1.5.7.11.4" class="indexterm" name="id-1.5.7.11.4"></a><a
      id="id-1.5.7.11.5" class="indexterm" name="id-1.5.7.11.5"></a><a
      id="id-1.5.7.11.6" class="indexterm" name="id-1.5.7.11.6"></a><a
      id="id-1.5.7.11.7" class="indexterm" name="id-1.5.7.11.7"></a><a
      id="id-1.5.7.11.8" class="indexterm" name="id-1.5.7.11.8"></a>
    <p class="title"><strong>Table 8.4. Character Types</strong></p>
    <table class="table" summary="Character Types" border="1">
      <colgroup> <col> <col> </colgroup> <thead> <tr>
          <th>Name</th>
          <th>Description</th>
        </tr>
      </thead> <tbody>
        <tr>
          <td><code class="type">character varying(<em
                class="replaceable"><code>n</code></em>)</code>, <code
              class="type">varchar(<em class="replaceable"><code>n</code></em>)</code></td>
          <td>variable-length with limit</td>
        </tr>
        <tr>
          <td><code class="type">character(<em class="replaceable"><code>n</code></em>)</code>,
            <code class="type">char(<em class="replaceable"><code>n</code></em>)</code></td>
          <td>fixed-length, blank padded</td>
        </tr>
        <tr>
          <td><code class="type">text</code></td>
          <td>variable unlimited length</td>
        </tr>
      </tbody>
    </table>
    <p></p>
    <div class="moz-cite-prefix">On 20/07/2023 16:46, Laurenz Albe
      wrote:<br>
    </div>
    <blockquote type="cite"
cite="mid:a0a7dceb61ab4ae3b2178566684fd3bdf087e698.camel@cybertec.at">
      <pre class="moz-quote-pre" wrap="">On Thu, 2023-07-20 at 15:46 +0200, Jef Mortelle wrote:
</pre>
      <blockquote type="cite">
        <pre class="moz-quote-pre" wrap="">So: not possible to have very little downtime if you have a database 
with al lot rows containing text  as datatype, as pg_upgrade needs 12hr 
for 24 milj rows in pg_largeobject.
</pre>
      </blockquote>
      <pre class="moz-quote-pre" wrap="">
To clarify: "text" is no problem at all.  Large objects are.

Yours,
Laurenz Albe
</pre>
    </blockquote>
  </body>
</html>

--------------JoSw52iLBflAe7XUs0Hinm8J--