> Or, better, persuade the app to label the value "
public.push_guid
" since that is the column's type...a type you haven't defined for us. If you get to add explicit casts this should be easy...but I'm not familiar with the framework you are using.
push_guid was a CHARACTER(36) column. I ended up converting it to CHARACTER VARYING(36).
Index is now being used and performance is as expected.
