|
We currently use expression indexes on our uuid/hash columns to make queries fast, because we realized shortly before 3.2.2 that we were issuing queries against columns cast to text, which prevented the indexes from being used. Expression indexes were a quick fix without much migration overhead, but long term we should get this buttoned down so that we're using consistent types internally (preferably bytea/uuid, but varchar works too).
This probably means either extending clojure.jdbc to do the type coercion on result sets, or adding some munging in the query namespaces to handle the byte arrays there.
|
