Re: order of nested loop - Mailing list pgsql-general

From Tom Lane
Subject Re: order of nested loop
Date
Msg-id 17253.1055889883@sss.pgh.pa.us
Whole thread Raw
In response to Re: order of nested loop  (Joseph Shraibman <jks@selectacast.net>)
Responses Re: order of nested loop  (Joseph Shraibman <joseph@xtenit.com>)
List pgsql-general
Joseph Shraibman <jks@selectacast.net> writes:
> How do I read that?  Is it creating a hash out of the data in d, then
> going through u doing a join?

Yeah.  Given the numbers of rows involved, the plan seems pretty
reasonable --- I doubt you can do a lot better within the context
you're showing here.  To make it faster you'll have to find a way
to not need to look at all the rows.

            regards, tom lane

pgsql-general by date:

Previous
From: "Jim C. Nasby"
Date:
Subject: Re: Sort memory not being released
Next
From: Ernest E Vogelsinger
Date:
Subject: Re: [PERFORM] Interesting incosistent query timing