Optimize performance by Tunning PostgreSQL Database.

PGTune — Postgres tuning

What is it? 🤔

Why do we need it? 🤔

# DB Version: 11
# OS Type: linux
# DB Type: web
# Total Memory (RAM): 14 GB
# CPUs num: 8
# Connections num: 100
# Data Storage: ssd

How To Implement it in your production 📝

sudo psql -U aa@xyz -d dbname
sudo vim /etc/postgressql/11/main/postgressql.conf
free -g
lscpu | egrep ‘Model name|Socket|Thread|NUMA|CPU\(s\)’
sudo vim /etc/postgressql/11/main/postgressql.conf
sudo service postgressql restart

I’m a Product Engineer at Gojek. I love to share my experiments, learnings via Blogs. https://twitter.com/vrushaliSRaut