Re: Compression of text columns - Mailing list pgsql-performance

From Tom Lane
Subject Re: Compression of text columns
Date
Msg-id 20646.1128955088@sss.pgh.pa.us
Whole thread Raw
In response to Compression of text columns  (Stef <svb@ucs.co.za>)
List pgsql-performance
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

pgsql-performance by date:

Previous
From: "Andy"
Date:
Subject: Re: Server misconfiguration???
Next
From: Christopher Kings-Lynne
Date:
Subject: Re: Server misconfiguration???