Re: PostgreSQL vs MySQL, and FreeBSD

From: Ow Mun Heng <Ow(dot)Mun(dot)Heng(at)wdc(dot)com>
To: Sebastian Hennebrueder <usenet(at)laliluna(dot)de>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: PostgreSQL vs MySQL, and FreeBSD
Date: 2007-11-16 09:43:05
Message-ID: 1195206185.29253.56.camel@neuromancer.home.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance


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.

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message hubert depesz lubaczewski 2007-11-16 09:45:41 Re: autovacuum: recommended?
Previous Message Gábor Farkas 2007-11-16 09:40:43 autovacuum: recommended?