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

From Stef
Subject Re: Compression of text columns
Date
Msg-id 20051010145700.586dc488@svb.ucs.co.za
Whole thread Raw
In response to Re: Compression of text columns  (Tino Wildenhain <tino@wildenhain.de>)
Responses Re: Compression of text columns  (Simon Riggs <simon@2ndquadrant.com>)
List pgsql-performance
Tino Wildenhain mentioned :
=> Well, text columns are automatically compressed via the toast mechanism.
=> This is handled transparently for you.

OK, I misread the documentation, and I forgot to mention that
I'm using postgres 7.3 and 8.0
It's actually the EXTERNAL storage type that is larger, not EXTENDED.
What kind of compression is used in the EXTERNAL storage type?
Is there any way to achieve better compression?

pgsql-performance by date:

Previous
From: "Steinar H. Gunderson"
Date:
Subject: Re: Text/Varchar performance...
Next
From: "Federico Simonetti (Liveye)"
Date:
Subject: Query performance on ILIKE with AND operator...