Received: from localhost (unknown [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 27A252E2E8B for ; Fri, 16 Nov 2007 05:44:18 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 36425-09 for ; Fri, 16 Nov 2007 05:44:11 -0400 (AST) Received: from wdscexfe02.sc.wdc.com (wdscexfe02.sc.wdc.com [129.253.170.52]) by postgresql.org (Postfix) with ESMTP id 4F76C2E2E97 for ; Fri, 16 Nov 2007 05:44:14 -0400 (AST) Received: from wdmyexbe03.my.asia.wdc.com ([129.253.105.55]) by wdscexfe02.sc.wdc.com with Microsoft SMTPSVC(6.0.3790.1830); Fri, 16 Nov 2007 01:43:54 -0800 Received: from 129.253.108.16 ([129.253.108.16]) by wdmyexbe03.my.asia.wdc.com ([129.253.105.55]) with Microsoft Exchange Server HTTP-DAV ; Fri, 16 Nov 2007 09:43:30 +0000 Received: from neuromancer by 129.253.105.55; 16 Nov 2007 17:43:06 +0800 Subject: Re: PostgreSQL vs MySQL, and FreeBSD From: Ow Mun Heng To: Sebastian Hennebrueder Cc: pgsql-performance@postgresql.org In-Reply-To: <47347F9F.1070309@laliluna.de> References: <47344D43.5090506@geri.cc.fer.hr> <47347F9F.1070309@laliluna.de> Content-Type: text/plain Content-Transfer-Encoding: 7bit Date: Fri, 16 Nov 2007 17:43:05 +0800 Message-Id: <1195206185.29253.56.camel@neuromancer.home.net> Mime-Version: 1.0 X-Mailer: Evolution 2.12.0 X-OriginalArrivalTime: 16 Nov 2007 09:43:55.0325 (UTC) FILETIME=[342496D0:01C82835] X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=1.331 tagged_above=0 required=5 tests=AWL=-0.737, BAYES_50=0.001, RCVD_NUMERIC_HELO=2.067 X-Spam-Level: * X-Archive-Number: 200711/237 X-Sequence-Number: 27652 On Fri, 2007-11-09 at 16:41 +0100, Sebastian Hennebrueder wrote: > If the queries are complex, this is understable. I had a performance > review of a Hibernate project (Java Object Relation Mapping) using > MySQL. ORM produces easily "complex" queries with joins and subqueries. > MySQL uses nested loops for subqueries which lead to performance issues > with growing database size. Even for Postgresql, nested loops are still evil and hampers performance.