From: Alvaro Herrera <alvherre@2ndquadrant.com>
To: John Scalia <jayknowsunix@gmail.com>
Cc: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Re: Autovacuum behavior
Date: Thu, 30 Jul 2015 15:59:39 -0300
Message-ID: <20150730185939.GT2441@postgresql.org> (raw)
In-Reply-To: <CABzCKRDtMfmgKFoMeTFDRGif+siQK9bXM4791ii8ZBJfORSFNA@mail.gmail.com>
References: <CABzCKRDtMfmgKFoMeTFDRGif+siQK9bXM4791ii8ZBJfORSFNA@mail.gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
John Scalia wrote:
> Hi all,
>
> The autovacuum settings for a 9.4.2 database are shown below, I'm not
> absolutely certain if I missed anything:
>
> autovacuum = on
> log_autovacuum_min_duration = 100
> autovacuum_max_workers = 15
> autovacuum_naptime = 10min
> #autovacuum_vacuum_threshold = 50
> autovacuum_analyze_threshold = 80
> autovacuum_vacuum_scale_factor = 0.1
> autovacuum_analyze_scale_factor = 0.2
> autovacuum_freeze_max_age = 100000000
> autovacuum_vacuum_cost_delay = 20ms
> autovacuum_vacuum_cost_limit = -1
What's the vacuum_cost_limit setting? Maybe they are sleeping for too
long, and don't have time to get to some of the other tables because all
15 workers are busy. This gets worse the more workers there are.
I don't think the 10min naptime is doing you any favors, is it?
If you want them to go faster, maybe you need to lower the cost_delay.
--
Álvaro Herrera http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: alvherre@2ndquadrant.com, jayknowsunix@gmail.com
Subject: Re: Autovacuum behavior
In-Reply-To: <20150730185939.GT2441@postgresql.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox