Yeah, it's hilariously good actually. I find myself evangelizing the search. It's brilliant, and for the first time in my life, I don't feel a need to organize my photos.
I love the search. My wife wanted a photo of my son at the park on the slide. So I searched for 'slide'. All my photos that I've taken with any slide in it show up.
Photo search is way-cool in Google Photos. Want to see every photo of beer? Search for it. Mountains, cars, places, a named person, animals, etc. I feel the need less and less to meta-tag my photos.
I just searched for "James in the Mountains" and got photos of my Son in the mountains.
I don't think postgres can do that :-)