In some situations it is worthwhile to rebuild indexes periodically with the REINDEX command or a series

It is a good idea to save the database server's log output somewhere, rather than just discarding it via /dev/null. The log output is invaluable

PostgreSQL databases require periodic maintenance known as vacuuming. For many installations, it is sufficient to