Shrink Postgres Tables / Databases

psql

With psql cli:

vacuum full;

also do:

reindex ;