Re: Table and Index compression

From: Ron Mayer <rm_pg(at)cheapcomplexdevices(dot)com>
To: PFC <lists(at)peufeu(dot)com>
Cc: "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org>, Ron Mayer <rm_pg(at)cheapcomplexdevices(dot)com>
Subject: Re: Table and Index compression
Date: 2009-08-06 23:14:33
Message-ID: 4A7B63D9.1050401@cheapcomplexdevices.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

I'm curious what advantages there are in building compression into
the database itself, rather than using filesystem-based compression.

I see ZFS articles[1] discuss how enabling compression
improves performance with ZFS; for Linux, Btrfs has compression
features as well[2]; and on Windows NTFS seems to too.

[1]http://blogs.sun.com/observatory/entry/zfs_compression_a_win_win
[2]http://lwn.net/Articles/305697/

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2009-08-06 23:15:23 Re: Array detection in pg_dump
Previous Message Tom Lane 2009-08-06 23:10:47 Re: mixed, named notation support