Postgres Pro
Downloads
Home   >   mailing lists

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

From David G. Johnston
Subject Re: PostgreSQL CHARACTER VARYING vs CHARACTER VARYING (Length)
Date
Msg-id CAKFQuwZpiNNtfn6oqkdWXXBVjOXdz6nZQZTxnRhJSzQBRqhwTQ@mail.gmail.com
Whole thread Raw
In response to Re: PostgreSQL CHARACTER VARYING vs CHARACTER VARYING (Length)  (Rui DeSousa <rui@crazybean.net>)
List pgsql-admin
Tree view
On Tue, Apr 28, 2020 at 5:40 PM Rui DeSousa <rui@crazybean.net> wrote:
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. 

I estimate the probability of ever desiring to reduce the length of a varchar field to be indistinguishable from zero.

David J.

pgsql-admin by date:

Previous
From: Rui DeSousa
Date:
Subject: Re: PostgreSQL CHARACTER VARYING vs CHARACTER VARYING (Length)
Next
From: raf
Date:
Subject: Re: PostgreSQL CHARACTER VARYING vs CHARACTER VARYING (Length)