Re: order of nested loop

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Joseph Shraibman <jks(at)selectacast(dot)net>
Cc: pgsql-general(at)postgreSQL(dot)org
Subject: Re: order of nested loop
Date: 2003-06-17 22:44:43
Message-ID: 17253.1055889883@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Joseph Shraibman <jks(at)selectacast(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message nikolaus 2003-06-17 22:45:38 Re: [PERFORM] Interesting incosistent query timing
Previous Message Jim C. Nasby 2003-06-17 22:12:51 Re: Sort memory not being released