HOW TO GET THE MOST OUT OF POSTGRES MEMORY SETTINGS

Summary from the TLDR Web Dev newsletter

Postgres uses shared buffers, the largest segment of RAM, to cache frequently accessed data pages. shared_buffers should typically be set to 25% of available RAM to optimize memory usage, but can be adjusted based on buffer cache utilization. Work memory, controlled by work_mem, is allocated per query node and should be set carefully to avoid excessive memory usage or disk spillage. This article goes into detail tips to reduce memory consumption.