Re: Are there plans to add data compression feature to postgresql? - Mailing list pgsql-general

From Joris Dobbelsteen
Subject Re: Are there plans to add data compression feature to postgresql?
Date
Msg-id 490DF464.4040805@familiedobbelsteen.nl
Whole thread Raw
In response to Re: Are there plans to add data compression feature to postgresql?  ("Grzegorz Jaśkiewicz" <gryzman@gmail.com>)
Responses Re: Are there plans to add data compression feature to postgresql?  (Craig Ringer <craig@postnewspapers.com.au>)
List 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

pgsql-general by date:

Previous
From: Andreas Kretschmer
Date:
Subject: Re: Error in Adding All Tables
Next
From: Joris Dobbelsteen
Date:
Subject: Re: Slow query performance