Re: PostgreSQL CHARACTER VARYING vs CHARACTER VARYING (Length) - Mailing list pgsql-admin

From Rui DeSousa
Subject Re: PostgreSQL CHARACTER VARYING vs CHARACTER VARYING (Length)
Date
Msg-id 6404DFBD-2864-473E-8807-C95D35C6C715@crazybean.net
Whole thread Raw
In response to Re: PostgreSQL CHARACTER VARYING vs CHARACTER VARYING (Length)  ("David G. Johnston" <david.g.johnston@gmail.com>)
Responses Re: PostgreSQL CHARACTER VARYING vs CHARACTER VARYING (Length)  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-admin


On Apr 28, 2020, at 8:34 PM, David G. Johnston <david.g.johnston@gmail.com> wrote:

Its less problematic now that increasing the generally arbitrary length doesn't require a table rewrite but you still need to rebuild dependent objects.


To increase a column length does not require a table rewrite or table scan; however, reducing its size will require a full table scan.  So cleaning up a schema like the one proposed sucks. 

pgsql-admin by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: PostgreSQL CHARACTER VARYING vs CHARACTER VARYING (Length)
Next
From: "David G. Johnston"
Date:
Subject: Re: PostgreSQL CHARACTER VARYING vs CHARACTER VARYING (Length)