Postgres Pro
Downloads
Home   >   mailing lists

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

From Ron Mayer
Subject Re: Are there plans to add data compression feature to postgresql?
Date
Msg-id 49092A34.8090504@cheapcomplexdevices.com
Whole thread Raw
In response to Re: Are there plans to add data compression feature to postgresql?  (Grant Allen <gxallen@gmail.com>)
Responses Re: Are there plans to add data compression feature to postgresql?  (Grant Allen <gxallen@gmail.com>)
List pgsql-general
Tree view 
Grant Allen wrote:
> ...warehouse...DB2...IBM is seeing typical
> storage savings in the 40-60% range

Sounds about the same as what compressing file systems claim:

http://opensolaris.org/os/community/zfs/whatis/
  "ZFS provides built-in compression. In addition to
   reducing space usage by 2-3x, compression also reduces
   the amount of I/O by 2-3x. For this reason, enabling
   compression actually makes some workloads go faster.

I do note that Netezza got a lot of PR around their
compression release; claiming it doubled performance.
Wonder if they added that at the file system or higher
in the DB.

pgsql-general by date:

Previous
From: Eus
Date:
Subject: Why Postgresql Public Schema Is Not Owned By The DB Owner By Default
Next
From: Klint Gore
Date:
Subject: Re: valid use of wildcard