Re: Compression of text columns

Поиск
Список
Период
Сортировка
От Stef
Тема Re: Compression of text columns
Дата
Msg-id 20051010145700.586dc488@svb.ucs.co.za
обсуждение исходный текст
Ответ на Re: Compression of text columns  (Tino Wildenhain <tino@wildenhain.de>)
Ответы Re: Compression of text columns  (Simon Riggs <simon@2ndquadrant.com>)
Список 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 по дате отправления:

Предыдущее
От: "Steinar H. Gunderson"
Дата:
Сообщение: Re: Text/Varchar performance...
Следующее
От: "Federico Simonetti (Liveye)"
Дата:
Сообщение: Query performance on ILIKE with AND operator...