On Wed, Oct 29, 2008 at 10:09 AM, 小波 顾 <guxiaobo1982@xxxxxxxxxxx> wrote:>> Data Compression>> The new data compression feature in SQL Server 2008 reduces the size of> tables, indexes or a subset of their partitions by storing fixed-length data> types in variable length storage format and by reducing the redundant data.> The space savings achieved depends on the schema and the data distribution.> Based on our testing with various data warehouse databases, we have seen a> reduction in the size of real user databases up to 87% (a 7 to 1 compression> ratio) but more commonly you should expect a reduction in the range of> 50-70% (a compression ratio between roughly 2 to 1 and 3 to 1). I'm sure this makes for a nice brochure or power point presentation,but in the real world I can't imagine putting that much effort into itwhen compressed file systems seem the place to be doing this. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)To make changes to your subscription:http://www.postgresql.org/mailpref/pgsql-general
