Thanks a lot for all the help, if you can lead me to any docs/articles, I'll gladly read them.
pgsql-performance by date:
Соглашаюсь с условиями обработки персональных данных