Lists <lists@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