Received: from maia.hub.org (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id 9B4F9632DF2 for ; Tue, 23 Mar 2010 20:31:01 -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 63126-03 for ; Tue, 23 Mar 2010 23:30:43 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail-yw0-f184.google.com (mail-yw0-f184.google.com [209.85.211.184]) by mail.postgresql.org (Postfix) with ESMTP id A17C0632B4B for ; Tue, 23 Mar 2010 20:30:50 -0300 (ADT) Received: by ywh14 with SMTP id 14so1069400ywh.15 for ; Tue, 23 Mar 2010 16:30:49 -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=8KFuok2IYEtQic/UMciN1hx75PqQ4xE6iPDVU3uEptE=; b=OvK70Y/XdJ2M1tPN+mdcTF2Crfe3cKA/mAw9lh9uAz7lZkN80p2svSBWHQScRKpvjh R42wk0sngtYI9QdS3bqtPO843LL2jetfwmiIeQLie55T3sD/i3RoNf+A9O3IPCjp3Doj oCByiKWfxaAcdAbFO7M9F+VveC5EoU6dtRUaU= 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=myAUlnG4JVIcuY7j8xMHzM8GpTGZoBUuLv+CF7A9ChXEIdq1ejfejkAnhfartolqv5 oJdx6/VvVWEG0ATbQOVnsY7Q/Tv2tMCNXinuGLymfCitfzu7ddOW1AKDwr6mn5KI8/bj NZNHMRzdTLTbVk6QwOnfI7ej3G5JFGui64/aE= MIME-Version: 1.0 Received: by 10.150.176.10 with SMTP id y10mr13238564ybe.79.1269387049111; Tue, 23 Mar 2010 16:30:49 -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 17:30:48 -0600 Message-ID: Subject: Re: mysql to postgresql, performance questions From: Scott Marlowe To: Dave Crooke Cc: Greg Smith , Tom Lane , "Ross J. Reedstrom" , pgsql-performance@postgresql.org Content-Type: text/plain; charset=ISO-8859-1 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-2.473 tagged_above=-10 required=5 tests=AWL=0.126, BAYES_00=-2.599 X-Spam-Level: X-Archive-Number: 201003/300 X-Sequence-Number: 38125 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.