Received: from maia.hub.org (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id 0A1CE632B03 for ; Tue, 23 Mar 2010 20:37:24 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024) with ESMTP id 64350-02 for ; Tue, 23 Mar 2010 23:37:05 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail-bw0-f216.google.com (mail-bw0-f216.google.com [209.85.218.216]) by mail.postgresql.org (Postfix) with ESMTP id D6EA66323A6 for ; Tue, 23 Mar 2010 20:37:11 -0300 (ADT) Received: by bwz8 with SMTP id 8so621768bwz.3 for ; Tue, 23 Mar 2010 16:37:09 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:received:in-reply-to:references :date:message-id:subject:from:to:cc:content-type; bh=0n9EheAPt28eHpxv3Ji+FWnJTdZbPuNpEEEj7SFUvQA=; b=xu1R/IVtFwA9leSRks89QqdFn/En+ufURk8ikof8iIPfFTNM3s7vTpU9tKQvWYRUjk kH4HNLzIEqpTb1In7JGZpmFY5LxsMO9GOqla9/s5dW3IwGOmRJnKj9/8Jn8oQyXEsboF pXy1gWAAEie2U0iu9xu1d2Q5hXGHk5ZrUbwV8= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :cc:content-type; b=gx381WVw8CA0MLeicZsVpm2ErxBAxUxEJ5Z0i50yEkDgp6AhbUMy9JAf+ZZLFkCDDy 501zQ1Y9JU6RsdOF54NQSIM6UuKqf60PlTNlwdNwojDdpksKsG+24zkFNttXrfN5RdOl ueeokMhzndcZILD/7IYR7L+yrbAaTQQRvTrDc= MIME-Version: 1.0 Received: by 10.204.48.144 with SMTP id r16mr3350315bkf.176.1269387429265; Tue, 23 Mar 2010 16:37:09 -0700 (PDT) In-Reply-To: References: <4BA23936.2030507@gmail.com> <4BA596D2.4050406@squeakycode.net> <20100323185232.GD6662@rice.edu> <5342.1269372121@sss.pgh.pa.us> <4BA934B9.9070401@2ndquadrant.com> Date: Tue, 23 Mar 2010 18:37:08 -0500 Message-ID: Subject: Re: mysql to postgresql, performance questions From: Dave Crooke To: Scott Marlowe Cc: Greg Smith , Tom Lane , "Ross J. Reedstrom" , pgsql-performance@postgresql.org Content-Type: multipart/alternative; boundary=000325554592cdea730482804ad0 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-2.46 tagged_above=-10 required=5 tests=AWL=0.138, BAYES_00=-2.599, HTML_MESSAGE=0.001 X-Spam-Level: X-Archive-Number: 201003/302 X-Sequence-Number: 38127 --000325554592cdea730482804ad0 Content-Type: text/plain; charset=ISO-8859-1 MyISAM is SQLLite with some threading ;-) On Tue, Mar 23, 2010 at 6:30 PM, Scott Marlowe wrote: > On Tue, Mar 23, 2010 at 5:07 PM, Dave Crooke wrote: > > What about InnoDB? > > Depends on what parts of mysql they otherwise use. There are plenty > of features that won't work if you're using non-myisam tables, like > full text search. I tend to think any full blown (or nearly so) db is > overkill for mythtv, and the use of something like sqllite or berkely > db tables is a better fit. > --000325554592cdea730482804ad0 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable MyISAM is SQLLite with some threading ;-)

On Tue, Mar 23, 2010 at 6:30 PM, Scott Marlowe <scott.marlowe@gmail.com> wrote:
On Tue, Mar 23, 2= 010 at 5:07 PM, Dave Crooke <dcrook= e@gmail.com> wrote:
> What about InnoDB?

Depends on what parts of mysql they otherwise use. =A0There are plenty
of features that won't work if you're using non-myisam tables, like=
full text search. =A0I tend to think any full blown (or nearly so) db is overkill for mythtv, and the use of something like sqllite or berkely
db tables is a better fit.

--000325554592cdea730482804ad0--