Subject Re: [Firebird-Architect] Compression
Author Dimitry Sibiryakov
27.09.2011 10:18, Thomas Steinmaurer wrote:
>> Records are already compressed as delta + RLE. Page level compression is pointless
>> because page of variable size is a headache.
> Still fixed page size on disk with compressed data.

And this is exactly why page compression is pointless: you are writing to disk full
page size anyway, no difference between page with uncompressed data and page with
compressed data + some filling zeros.

> > What is "table level" compression I have no idea.
> Compression of a particular table instead of the entire database/pages.

It sounds as a record compression turned on for particular tables only. Nice for Oracle
who didn't have compression before, but strange for FB who always compressed data.