Hi, > I want to ask a question about json index. > Can I make a index on a field of a json column? > e.g, for table 'json_tab' you given, can I run something like "create > index 'json_index' on json_tab::key"? >
Yes. Here it is an example: http://stackoverflow.com/questions/17807030/how-to-create-index-on-json-field-in-postgres-9-3 Also, in 9.4 we got JSONB data type, which may enhance JSON fields performance.
