Received: from maia.hub.org (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 16193633D28 for ; Tue, 23 Mar 2010 21:03:35 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 21999-05-3 for ; Wed, 24 Mar 2010 00:03:24 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail-gw0-f46.google.com (mail-gw0-f46.google.com [74.125.83.46]) by mail.postgresql.org (Postfix) with ESMTP id 6439F632CFF for ; Tue, 23 Mar 2010 21:01:58 -0300 (ADT) Received: by gwaa18 with SMTP id a18so1724483gwa.19 for ; Tue, 23 Mar 2010 17:01:56 -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 :content-transfer-encoding; bh=GloczERiwmSqLhWBBSByw1TRWksKxrvK+uK/eD9ASEY=; b=ejZcut36cK/ON0y/ydSZCnnrbHubxUjoKR0a5fFMIg1xKb3/Ev5hltx+jrhwUqF/gn hHB/K/Qgfhy2z7/hZWdCveTFtMJNjVYxX1d/ACHYzFun7/LBwrNATEXIuBzRNKTc0498 VqeIxvlIbE6yjHbdbB2S2i+c98TaaQwRcBTto= 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:content-transfer-encoding; b=IYXVhe6Q/8uMJzt/uC7UIwXw/HGacfnGxIP+GWA1ePDLY6eAJCAPcTTBql9NQqr903 +ofaTXU3PqZouT7QwnFTjClbe1Ulq3UtmDRoRfkjXVMHGFAb7dbDgLdbJtM1BQlYnCcd 0pumRYNaDbPDnenFYwBLvR8u48Uej1Vi/+FR0= MIME-Version: 1.0 Received: by 10.150.61.4 with SMTP id j4mr1932040yba.303.1269388916766; Tue, 23 Mar 2010 17:01:56 -0700 (PDT) In-Reply-To: <10261.1269387333@sss.pgh.pa.us> References: <4BA23936.2030507@gmail.com> <4BA596D2.4050406@squeakycode.net> <20100323185232.GD6662@rice.edu> <5342.1269372121@sss.pgh.pa.us> <4BA934B9.9070401@2ndquadrant.com> <10261.1269387333@sss.pgh.pa.us> Date: Tue, 23 Mar 2010 18:01:56 -0600 Message-ID: Subject: Re: mysql to postgresql, performance questions From: Scott Marlowe To: Tom Lane Cc: Dave Crooke , Greg Smith , "Ross J. Reedstrom" , pgsql-performance@postgresql.org Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-2.599 tagged_above=-10 required=5 tests=BAYES_00=-2.599 X-Spam-Level: X-Archive-Number: 201003/303 X-Sequence-Number: 38128 On Tue, Mar 23, 2010 at 5:35 PM, Tom Lane wrote: > Scott Marlowe writes: >> On Tue, Mar 23, 2010 at 5:07 PM, Dave Crooke 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. > > That's apparently also the position of their lead developer; although > considering he's not actually done anything about it for six or more > years, it seems like quite a lame excuse for blocking ports to other > DBs. Methinks he's big on his "comfort-zone".