Re: text fields and performance for ETL - Mailing list pgsql-docs

On Thu, 2021-11-11 at 09:44 +0000, Grega Jesih wrote:
> with this approach, why don't you eliminate char and varchar then ?
> Thanks for thinking over.

Two reasons:

- the SQL standard requires these types

- sometimes you want to enforce a length limit, and a "type modifier" like
  varchar(30) is cheaper than a check constraint

Yours,
Laurenz Albe