Re: Upgrade from PG12 to PG

Jef Mortelle <jefmortelle@xxxxxxxxx> · Thu, 20 Jul 2023 16:49:05 +0200



    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

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