Postgres Pro
Downloads
Home   >   mailing lists

Re: Left Join Not Using Index? - Mailing list pgsql-general

From Tom Lane
Subject Re: Left Join Not Using Index?
Date
Msg-id 24197.1051074579@sss.pgh.pa.us
Whole thread Raw
In response to Re: Left Join Not Using Index?  ("Dann Corbit" <DCorbit@connx.com>)
Responses Re: Left Join Not Using Index?  (Hunter Hillegas <lists@lastonepicked.com>)
List pgsql-general
Tree view 
"Dann Corbit" <DCorbit@connx.com> writes:
> This guess:
>> 40855.59 msec
> Certainly seems slower than this one:
>> 13108.33 msec

Those are not guesses, those are measurements.  Translation: the planner
made the right choice here.  (Hot diggety ;-))

            regards, tom lane

pgsql-general by date:

Previous
From: Hunter Hillegas
Date:
Subject: Re: Left Join Not Using Index?
Next
From: Hunter Hillegas
Date:
Subject: Re: Left Join Not Using Index?