Re: Nested Loop "Killer" on 8.1 - Mailing list pgsql-performance

From Mark Mielke
Subject Re: Nested Loop "Killer" on 8.1
Date
Msg-id 4A43E4C6.5030506@mark.mielke.cc
Whole thread Raw
In response to Re: Nested Loop "Killer" on 8.1  (Greg Stark <gsstark@mit.edu>)
List pgsql-performance
On 06/25/2009 04:36 PM, Greg Stark wrote:
AND
   web_user_property_directory_outbox.prop_key like
'location_node_directory_outbox'   
Why use "like" for a constant string with no % or _ characters? If you
used = the planner might be able to come up with a better estimate

Any reason why "like" with a constant string without % or _ is not optimized to = today?

Cheers,
mark

-- 
Mark Mielke <mark@mielke.cc>

pgsql-performance by date:

Previous
From: Greg Stark
Date:
Subject: Re: Nested Loop "Killer" on 8.1
Next
From: Tom Lane
Date:
Subject: Re: Nested Loop "Killer" on 8.1