Re: Nested loop performance

From: Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com>
To: Nick Fankhauser <nickf(at)ontko(dot)com>
Cc: "Pgsql-Performance(at)Postgresql(dot) Org" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Nested loop performance
Date: 2003-12-17 01:17:26
Message-ID: 20031216171625.A31260@megazone.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance


On Tue, 16 Dec 2003, Nick Fankhauser wrote:

> Is there a more efficient means than a nested loop to handle such a join?
> Would a different method be chosen if there was exactly one row in
> actor_summary for every row in actor?

As a question, what does explain analyze give you if you
set enable_nestloop=false; before trying the query?

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Christopher Kings-Lynne 2003-12-17 01:17:28 Re: Optimizing FK & PK performance...
Previous Message Jenny Zhang 2003-12-17 00:07:26 Re: update slows down in pl/pgsql function