Search Postgresql Archives

Re: Cancelling of autovacuums considered harmful

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On 02/26/2014 08:56 AM, Alvaro Herrera wrote:
...
No matter how heavily updated, regular activity should not cause
autovacuum kills.  Only heavier operations would do that (say ALTER
TABLE, etc).

"Considered harmful" got my attention. What, if any, known harm is caused?

We have many errors of this type but in our case most are due to batch processes that have a vacuum embedded at appropriate points in the string of commands in order to avoid excessive bloat and to ensure the tables are analyzed for the following steps. Occasionally the autovacuum triggers before the manual but gets canceled.

Any harm?

Cheers,
Steve



--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general




[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux