Re: PostgreSQL vs MySQL, and FreeBSD

From: Josh Trutwin <josh(at)trutwins(dot)homeip(dot)net>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: PostgreSQL vs MySQL, and FreeBSD
Date: 2007-11-16 20:36:50
Message-ID: 20071116143650.03e994ad@prokofiev.trutwins.homeip.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Fri, 16 Nov 2007 11:06:11 -0500
"Jonah H. Harris" <jonah(dot)harris(at)gmail(dot)com> wrote:

> On Nov 16, 2007 10:56 AM, Dave Dutcher <dave(at)tridecap(dot)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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Jonah H. Harris 2007-11-16 20:53:51 Re: PostgreSQL vs MySQL, and FreeBSD
Previous Message Bill Moran 2007-11-16 19:51:35 Re: Clustered/covering indexes (or lack thereof :-)