Re: Time to put theory to the test?

From: <gnuoytr(at)rcn(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Time to put theory to the test?
Date: 2011-04-26 15:20:33
Message-ID: 201104261520.060332@ms14.lnh.mail.rcn.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

---- Original message ----
>Date: Tue, 26 Apr 2011 09:13:17 -0500
>From: pgsql-performance-owner(at)postgresql(dot)org (on behalf of J Sisson <sisson(dot)j(at)gmail(dot)com>)
>Subject: Re: [PERFORM] Time to put theory to the test?
>To: Rob Wultsch <wultsch(at)gmail(dot)com>
>Cc: "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
>
>On Mon, Apr 25, 2011 at 10:04 PM, Rob Wultsch <wultsch(at)gmail(dot)com> wrote:
>> Tip from someone that manages thousands of MySQL servers: Use InnoDB
>> when using MySQL.
>
>Granted, my knowledge of PostgreSQL (and even MSSQL) far surpasses my
>knowledge of MySQL, but if InnoDB has such amazing benefits as being
>crash safe, and even speed increases in some instances, why isn't
>InnoDB default?

because it is. recently.
http://dev.mysql.com/doc/refman/5.5/en/innodb-default-se.html

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2011-04-26 15:51:17 Re: Time to put theory to the test?
Previous Message Joel Reymont 2011-04-26 15:16:19 optimizing a cpu-heavy query