Extend RAM

Swap extends RAM and helps prevent OOM crashes. Add a swap file before installing PostgreSQL:

# Check for existing swap
sudo swapon --show

# Create a 2 GB swap file
sudo fallocate -l 2G /swapfile

# Secure and enable it
sudo chmod 600 /swapfile
sudo mkswap /swapfile
sudo swapon /swapfile

Make it permanent by appending the line to /etc/fstab:

echo '/swapfile none swap sw 0 0' | sudo tee -a /etc/fstab

Verify:

sudo swapon --show
free -h

​Extend RAM

Extend RAM