Re: PostgreSQL vs MySQL, and FreeBSD - Mailing list pgsql-performance

From Josh Trutwin
Subject Re: PostgreSQL vs MySQL, and FreeBSD
Date
Msg-id 20071116143650.03e994ad@prokofiev.trutwins.homeip.net
Whole thread Raw
In response to Re: PostgreSQL vs MySQL, and FreeBSD  ("Jonah H. Harris" <jonah.harris@gmail.com>)
Responses Re: PostgreSQL vs MySQL, and FreeBSD
List pgsql-performance
On Fri, 16 Nov 2007 11:06:11 -0500
"Jonah H. Harris" <jonah.harris@gmail.com> wrote:

> On Nov 16, 2007 10:56 AM, Dave Dutcher <dave@tridecap.com> wrote:
> > I don't know about that.  There are times when it is the right
> > plan:
>
> Agreed.  IMHO, there's nothing wrong with nested-loop join as long
> as it's being used properly.

Can you explain further please?  (I'm not disagreeing with you, just
want to know when nested loops are not used properly - does the
planner make mistakes that you have to watch out for?)

Thx,

Josh

pgsql-performance by date:

Previous
From: Bill Moran
Date:
Subject: Re: Clustered/covering indexes (or lack thereof :-)
Next
From: "Jonah H. Harris"
Date:
Subject: Re: PostgreSQL vs MySQL, and FreeBSD