If you want to search by geographical coordinates, you could use a gist index which can optimize that sort of things (like retrieving all rows which fit in a box).
pgsql-performance by date:
Соглашаюсь с условиями обработки персональных данных