Received: from localhost (unknown [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 375FB9F96CC for ; Fri, 9 Nov 2007 11:57:55 -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 74922-01 for ; Fri, 9 Nov 2007 11:57:31 -0400 (AST) Received: from wx-out-0506.google.com (wx-out-0506.google.com [66.249.82.224]) by postgresql.org (Postfix) with ESMTP id 26DEF9F959D for ; Fri, 9 Nov 2007 11:57:37 -0400 (AST) Received: by wx-out-0506.google.com with SMTP id r21so340388wxc for ; Fri, 09 Nov 2007 07:57:35 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; bh=qTyRsgdq+usQ7tY8w2uG+qBJztHLtekqUMMljkWMAww=; b=YQ5+IJCeT1LLz23byrhGnTgTlYGJyAlqjagnZnyMqaG9pp7cbQxIc9aock4VhlK4X4pWs/R7a2SnEa1bkDC0qb6eH56Vi7rCPOIomNVbRMrE0KrLFvEaAaVz8wCUmELFPSjav9JLuMwpaDd+MYlk3lED5NtqstO5tmlKMn4yx3g= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=UimJ/e6N/cqnfEW9noaoGKkDRiX22CrUMMTYbiHPLGuI1fc/Cnw6TMT22i170myNEPMI/urg98IqlFdifQedPyQDRyIZHwCGLzryQNqFcM6VKLuv0iy6li0/JPnLiwpknLNvmb5NpPfBs3wjHCNxWKC25aHyFJUWAubvtO5saFA= Received: by 10.67.27.3 with SMTP id e3mr1067459ugj.1194623853925; Fri, 09 Nov 2007 07:57:33 -0800 (PST) Received: by 10.67.95.18 with HTTP; Fri, 9 Nov 2007 07:57:33 -0800 (PST) Message-ID: Date: Fri, 9 Nov 2007 09:57:33 -0600 From: "Scott Marlowe" To: "Sebastian Hennebrueder" Subject: Re: PostgreSQL vs MySQL, and FreeBSD Cc: pgsql-performance@postgresql.org In-Reply-To: <47347F9F.1070309@laliluna.de> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <47344D43.5090506@geri.cc.fer.hr> <47347F9F.1070309@laliluna.de> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200711/137 X-Sequence-Number: 27552 On Nov 9, 2007 9:41 AM, 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. > > They state in their documentation that for version 5.2 there are > improvements planned regarding this kind of query. So, MySQL 5.2 will be catching up to version 7.1 or 7.2 of PostgreSQL in that regard?