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
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
