[postgres] remove node_pos index which is not immutable

This caused subtle bugs when ALTER TABLE with search_title was
called. It is a wrong practice to define an index immutable when in
fact it's not. The count(id) part makes it mutable in fact.