Re: Are there plans to add data compression feature to postgresql?

From: Joris Dobbelsteen <joris(at)familiedobbelsteen(dot)nl>
To: Grzegorz Jaśkiewicz <gryzman(at)gmail(dot)com>
Cc: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>, Steve Atkins <steve(at)blighty(dot)com>, pgsql General <pgsql-general(at)postgresql(dot)org>
Subject: Re: Are there plans to add data compression feature to postgresql?
Date: 2008-11-02 18:41:40
Message-ID: 490DF464.4040805@familiedobbelsteen.nl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Grzegorz Jaśkiewicz wrote, On 30-10-08 12:13:
>
> it should, every book on encryption says, that if you compress your data
> before encryption - its better.

Those books also should mention that you should leave this subject to
experts and have numerous examples on systems that follow the book, but
are still broken. There are other techniques as well that make breaking
it harder, such as the CBC and CTS modes.

Using compression consumes processing power and resources, easing DoS
attacks a lot.

Also I still have to see an compression algorithm that can sustain over
(or even anything close to, for that matter) 100MB/s on todays COTS
hardware. As TOAST provides compression, maybe that data can be
transmitted in compressed manner (without recompression).

- Joris

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Shashank Mujumdar 2008-11-02 19:15:44 Error in installation...
Previous Message Joris Dobbelsteen 2008-11-02 18:26:05 Re: Slow query performance