Lists <li...@benjamindsmith.com> writes: > Even so, if I felt the need to keep autovacuum off, what would I need to > run regularly in order to keep things neat and tidy under the hood? > Would a simple "vacuum" within each database suffice? Should I be logged > in as the database owner or as an administrative user?
A plain "vacuum" (or probably better, "vacuum analyze") done as superuser will suffice, as long as you do it often enough. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general