Stef <svb@ucs.co.za> writes:
> I saw that the default storage type for text columns is
> "EXTENDED" which, according to the documentation, uses up extra
> space to make possible substring functioning faster.
You misread it. EXTENDED does compression by default on long strings.
EXTERNAL is the one that suppresses compression.
regards, tom lane