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

From Tom Lane
Subject Re: order of nested loop
Date
Msg-id 13145.1055864458@sss.pgh.pa.us
Whole thread Raw
In response to Re: order of nested loop  (Jean-Luc Lachance <jllachan@nsd.ca>)
List pgsql-general
Jean-Luc Lachance <jllachan@nsd.ca> writes:
> I am currious.  Why perform a sort first?  Would it not be more
> efficient to create an in memory index on the fly?

Why would you think that?  Creating an index involves a sort ...
there's no free lunch there that I can see.

            regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Sort memory not being released
Next
From: Jean-Luc Lachance
Date:
Subject: Re: order of nested loop