Basic practices for optimizing read and write performance in PostgreSQL(vettabase.com)

https://vettabase.com/blog/optimize-read-and-write-performance-in-postgresql/