autovacuum workers warning

From: Euler Taveira de Oliveira <euler(at)timbira(dot)com>
To: Pgsql Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: autovacuum workers warning
Date: 2011-10-25 19:56:12
Message-ID: 4EA7145C.8060709@timbira.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi,

Some time ago [1], I proposed print a message every time there isn't
autovacuum slots available and it asks for another one. It is not a complete
solution for autovacuum tuning but it would at least give us a hint that
number of workers is insufficient to keep up with the current load. The
accurate number of slots needed would be the optimal solution but that
information is not free (it would have to check every table in the databases
available to get the approximate number of slots needed. Approximate because
some table could be finishing the operation). A new warning is better than
nothing. If we decided to improve this area in a future we should remove the
warning but right now it would be an excelent hint to tune autovacuum.

[1] http://archives.postgresql.org/pgsql-hackers/2011-06/msg00678.php

--
Euler Taveira de Oliveira - Timbira http://www.timbira.com.br/
PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento

Attachment Content-Type Size
av.diff text/x-patch 620 bytes

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Chris Redekop 2011-10-25 21:06:14 Re: Hot Backup with rsync fails at pg_clog if under load
Previous Message Alexander Korotkov 2011-10-25 18:48:05 Re: GiST for range types (was Re: Range Types - typo + NULL string constructor)