On 11/07/2012 12:42 PM, Tom Lane wrote:
>> ... because it
>> >occasionally causes transactions and queries to hang when an update
>> >causes a vacuum mid-day, effectively taking us offline randomly.
> I suspect this claim is based on ancient and no longer very relevant
> experience.
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?
Thanks,
Ben