Re: Index not used

<div style="font-family: Verdana;font-size: 12.0px;"><div class="gmail_default" style="font-family: arial , helvetica ,
sans-serif;display:inline;">> ​Or, better, persuade the app to label the value "</div><div class="gmail_default"
style="font-family:arial , helvetica , sans-serif;display: inline;">​</div><div>public.push_guid <div
class="gmail_default"style="font-family: arial , helvetica , sans-serif;display: inline;">​" since that is the column's
type​...atype you haven't defined for us.  If you get to add explicit casts this should be easy...but I'm not familiar
withthe framework you are using.</div><div class="gmail_default" style="font-family: arial , helvetica ,
sans-serif;display:inline;"> </div><div class="gmail_default" style="font-family: arial , helvetica ,
sans-serif;display:inline;"> </div><div class="gmail_default" style="font-family: arial , helvetica ,
sans-serif;display:inline;">push_guid was a CHARACTER(36) column. I ended up converting it to CHARACTER
VARYING(36).</div><divclass="gmail_default" style="font-family: arial , helvetica , sans-serif;display: inline;">Index
isnow being used and performance is as expected.</div><div class="gmail_default" style="font-family: arial , helvetica
,sans-serif;display: inline;"> </div><div class="gmail_default" style="font-family: arial , helvetica ,
sans-serif;display:inline;">Thanks a lot</div><div class="gmail_default" style="font-family: arial , helvetica ,
sans-serif;display:inline;">Meike</div></div></div>