On Fri, Jun 25, 2010 at 8:56 AM, Scott Marlowe <scott.marlowe@gmail.com> wrote:
> On Fri, Jun 25, 2010 at 11:48 AM, Rob Wultsch <wultsch@gmail.com> wrote:
>> - Innodb : The primary transactional storage engine for MySQL. It does
>> not have all the features of PG (like check contraints), but it has
>> some features (like Compression!!!) which are *exceptionally* useful.
>
> You do know that pg has compression for text types built in already,
> right? I'm sure there are subtle differences in the way compression
> is done in each engine, just pointing that out.
>
I do, but TOAST is a very different animal than compression at the
page level. The innodb buffer pool is also effectively compressed
which allows for far greater use of memory.
--
Rob Wultsch
wultsch@gmail.com