On Fri, Jun 25, 2010 at 8:56 AM, Scott Marlowe <scott.marl...@gmail.com> wrote: > On Fri, Jun 25, 2010 at 11:48 AM, Rob Wultsch <wult...@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 wult...@gmail.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
