Re: Nested loop performance - Mailing list pgsql-performance

From Stephan Szabo
Subject Re: Nested loop performance
Date
Msg-id 20031216171625.A31260@megazone.bigpanda.com
Whole thread Raw
In response to Nested loop performance  ("Nick Fankhauser" <nickf@ontko.com>)
Responses Re: Nested loop performance
List 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?

pgsql-performance by date:

Previous
From: Christopher Kings-Lynne
Date:
Subject: Re: Optimizing FK & PK performance...
Next
From: David Shadovitz
Date:
Subject: Why is restored database faster?