Is there a way to use indexes for queries like: select field from table where field like 'abc%' (i.e. filter for string fields that begin with something) ?
pgsql-performance by date:
Соглашаюсь с условиями обработки персональных данных