Re: autovacuum worker running amok - and me too ;)

From: Kevin Grittner <kgrittn(at)ymail(dot)com>
To: wambacher <wnordmann(at)gmx(dot)de>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: autovacuum worker running amok - and me too ;)
Date: 2015-03-05 14:41:54
Message-ID: 484077311.3364656.1425566514148.JavaMail.yahoo@mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

wambacher <wnordmann(at)gmx(dot)de> wrote:
> watching the memory usage of the autovaccum process: is was getting bigger

> and bigger at nearly constant speed. some MB per minute, iir.

What are your settings for maintenance_work_mem and autovacuum_max_workers?

--
Kevin Grittner
EDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Igor Neyman 2015-03-05 14:58:53 Re: Sharing data between stored functions?
Previous Message Samuel Smith 2015-03-05 14:39:46 Re: Partitioning and constraint exclusion