Posts Tagged: PostgreSQL

RDS Instance Sizes, maximum concurrent connections

amazon_rds_logo

RDS Class max_connections

t1.micro 34
m1.small 125
m1.medium 296
m1.large 623
m1.xlarge 1263
m2.xlarge 1441
m2.2xlarge 2900
m2.4xlarge 5816

CLI Database optimization

MySQL:

sudo apt-get install mysql-client

mysqlcheck -h yourdatabasehost -u root -p --auto-repair --check --all-databases
mysqlcheck -h yourdatabasehost -u root -p --auto-repair --optimize --all-databases

PostgreSQL:

Vacuum
vacuumdb -afvz -h yourdatabasehost -u postgres

ReindexDB
reindexdb -a -h yourdatabasehost -u postgres