2017-07-14 UTC
# 
saranix puckipedia: postgres can index on text columns just fine (default is btree hashtable-like index). varchars are crappy for other reasons, avoid them, always use text instead. I didn't understand the other pg ques but also FYI pg has jsonb indexing too