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