X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 723C011F66FE for ; Wed, 19 Apr 2006 12:42:30 -0300 (ADT) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Score: 0.1 X-Spam-Level: X-Spam-Status: No, score=0.1 required=5 tests=[AWL=0.100] Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id Bu0qPIcpv6Za for ; Wed, 19 Apr 2006 12:42:23 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from peufeu.com (boutiquenumerique.com [82.67.9.10]) by postgresql.org (Postfix) with ESMTP id 3A2DB11F66C4 for ; Wed, 19 Apr 2006 12:42:22 -0300 (ADT) Received: (qmail 4755 invoked from network); 19 Apr 2006 17:42:21 +0200 Received: from boutiquenumerique.com (HELO apollo13) (82.67.9.10) by boutiquenumerique.com with SMTP; 19 Apr 2006 17:42:21 +0200 To: "Pgsql performance" Subject: Re: Inserts optimization? References: <6BCB9D8A16AC4241919521715F4D8BCEA352AE@algol.sollentuna.se> <44462849.3070209@logix-tt.com> <1145460130.23538.119.camel@state.g2switchworks.com> <26519.1145460679@sss.pgh.pa.us> Message-ID: Date: Wed, 19 Apr 2006 17:42:17 +0200 From: PFC Content-Type: text/plain; format=flowed; delsp=yes; charset=utf-8 MIME-Version: 1.0 Content-Transfer-Encoding: 8bit In-Reply-To: <26519.1145460679@sss.pgh.pa.us> User-Agent: Opera M2/8.51 (Linux, build 1462) X-Archive-Number: 200604/431 X-Sequence-Number: 18515 > Isn't MyISAM still the default over there? Yes, it's the default. Personnally I compile MySQL without InnoDB... and for any new development I use postgres. > It's hardly likely that the average MySQL user would use anything but > the default table type ... Double yes ; also many hosts provide MySQL 4.0 or even 3.x, both of which have no subquery support and are really brain-dead ; and most OSS PHP apps have to be compatible... argh.