PostgreSQL topics
vacuum
When the database is in trouble, do a full database vacuum in standalone mode.postgres -D /usr/local/pgsql/data some_database vacuum full; OR If vacuum full is not possible, vacuumdb -a -z
List databases
psql -l
Create database
CREATE DATABASE d1 WITH OWNER=some_user ENCODING='UTF8' ;
Query running processes
select * from pg_stat_activity;
