Re: [GENERAL] Compression hacks?

2011-02-24 Thread John R Pierce
On 02/24/11 10:55 PM, Yang Zhang wrote: For various workloads, compression could be a win on both disk space and speed (see, e.g., http://blog.oskarsson.nu/2009/03/hadoop-feat-lzo-save-disk-space-and.html). I realize Postgresql doesn't have general table compression a la InnoDB's row_format=com

[GENERAL] Compression hacks?

2011-02-24 Thread Yang Zhang
For various workloads, compression could be a win on both disk space and speed (see, e.g., http://blog.oskarsson.nu/2009/03/hadoop-feat-lzo-save-disk-space-and.html). I realize Postgresql doesn't have general table compression a la InnoDB's row_format=compressed (there's TOAST for large values and