At 05:24 02/11/2009, you wrote:
>The only reason I can think of for wanting to compress very small
>datums is if you have a gajillion of them, they're highly
>compressible, and you have extra CPU time coming out of your ears. In
>that case - yeah, you might want to think about pre-compressing the
On Sun, Nov 1, 2009 at 11:53 AM, Shaul Dar wrote:
> I am aware of the TOAST mechanism (actually complained about it in this
> forum...). The text fields I have are below the limits that trigger this
> mechanism, and also I may want to compress specific fields, not all of them.
> And also I have pe
On Sun, Nov 1, 2009 at 9:53 AM, Shaul Dar wrote:
> Guys,
>
> I am aware of the TOAST mechanism (actually complained about it in this
> forum...). The text fields I have are below the limits that trigger this
> mechanism, and also I may want to compress specific fields, not all of them.
> And also
On Sun, 2009-11-01 at 18:53 +0200, Shaul Dar wrote:
> I am aware of the TOAST mechanism (actually complained about it in
> this forum...). The text fields I have are below the limits that
> trigger this mechanism,
Have you proved somehow that compressing tiny values has any value?
> and also I m
Guys,
I am aware of the TOAST mechanism (actually complained about it in this
forum...). The text fields I have are below the limits that trigger this
mechanism, and also I may want to compress *specific* fields, not all of
them. And also I have performance concerns as TOAST splits tables and can
On Sun, Nov 1, 2009 at 7:56 AM, Pavel Stehule wrote:
> 2009/11/1 Shaul Dar :
>> Hi,
>>
>> I have several long text fields in my DB that I would love to compress
>> (descriptions, URLs etc). Can you tell me what options exists in PG
>> (+pointers please), typical effect on space and run time?
>
> H
Shaul Dar wrote:
> Hi,
>
> I have several long text fields in my DB that I would love to compress
> (descriptions, URLs etc). Can you tell me what options exists in PG
> (+pointers please), typical effect on space and run time?
variable length text fields .. e.g TEXT will automatically be stored
2009/11/1 Shaul Dar :
> Hi,
>
> I have several long text fields in my DB that I would love to compress
> (descriptions, URLs etc). Can you tell me what options exists in PG
> (+pointers please), typical effect on space and run time?
Hello
You can do nothing. PostgreSQL compresses data automatical
Hi,
I have several long text fields in my DB that I would love to compress
(descriptions, URLs etc). Can you tell me what options exists in PG
(+pointers please), typical effect on space and run time?
Thanks,
-- Shaul
