Need complete information or advice with examples of performance optimization in PostgreSQL?

Question

PostgreSQL

Good day, I searched for something, I found something I didn’t (probably searched badly), but still, many points are not clear, especially about indexes and how to optimally configure postgresql (in general, how to achieve maximum optimal performance) Guys, help me find good and complete information (format and size has no difference video, topic) with examples is desirable.
What I found:
The whole truth about indexes in PostgreSQL, Oleg Bartunov...
Query optimization. EXPLAIN Basics in PostgreSQL ...
Query Optimization. EXPLAIN Basics in PostgreSQL ...
Query Optimization. EXPLAIN basics in PostgreSQL...
Thanks in advance!

Answer 1

postgresql.leopard.in.ua