how about normalizing the schema for start ? by the looks of it, you have huge table,with plenty of varchars, that smells like bad design of db.
pgsql-performance by date:
Соглашаюсь с условиями обработки персональных данных