Re: Compression of text columns

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Stef <svb(at)ucs(dot)co(dot)za>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Compression of text columns
Date: 2005-10-10 14:38:08
Message-ID: 20646.1128955088@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Stef <svb(at)ucs(dot)co(dot)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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Christopher Kings-Lynne 2005-10-10 14:56:41 Re: Server misconfiguration???
Previous Message Andy 2005-10-10 14:31:10 Re: Server misconfiguration???