From: Mike Schanne <mschanne@kns.com>
To: Michael Lewis <mlewis@entrata.com>
Cc: 'pgsql-performance@postgresql.org' <pgsql-performance@postgresql.org>
Subject: RE: autovacuum locking question
Date: Thu, 5 Dec 2019 23:18:12 +0000
Message-ID: <d5fca64e56a64011afe41a2a44726bda@USEPRDEX1.corp.kns.com> (raw)
In-Reply-To: <CAHOFxGqq6O6UGH08-kqeMBKeqhYzLu2b0QtQ4p1DJG-GFL7Vxg@mail.gmail.com>
References: <0871fcf35ceb4caa8a2204ca9c38e330@USEPRDEX1.corp.kns.com>
<CAHOFxGqq6O6UGH08-kqeMBKeqhYzLu2b0QtQ4p1DJG-GFL7Vxg@mail.gmail.com>
In this particular case autovacuum_count is 0. n_live_tup is 659,631 and n_dead_tup is 3,400,347.
We are using the default vacuum parameters.
From: Michael Lewis [mailto:mlewis@entrata.com]
Sent: Thursday, December 05, 2019 5:49 PM
To: Mike Schanne
Cc: pgsql-performance@postgresql.org
Subject: Re: autovacuum locking question
On Thu, Dec 5, 2019 at 3:26 PM Mike Schanne <mschanne@kns.com<mailto:mschanne@kns.com>> wrote:
I am concerned that if the autovacuum is constantly canceled, then the table never gets cleaned and its performance will continue to degrade over time. Is it expected for the vacuum to be canceled by an insert in this way?
We are using postgres 9.6.10.
Have you checked when the table was last autovacuumed in pg_stat_user_tables? If the autovacuum count is high and timestamp of last run is relatively current, then no reason for concern as far as I can figure.
Have you already configured (non-default values) for autovacuum options for your system or this table?
________________________________
This email is non-binding, is subject to contract, and neither Kulicke and Soffa Industries, Inc. nor its subsidiaries (each and collectively “K&S”) shall have any obligation to you to consummate the transactions herein or to enter into any agreement, other than in accordance with the terms and conditions of a definitive agreement if and when negotiated, finalized and executed between the parties. This email and all its contents are protected by International and United States copyright laws. Any reproduction or use of all or any part of this email without the express written consent of K&S is prohibited.
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-performance@postgresql.org
Cc: mschanne@kns.com, mlewis@entrata.com
Subject: RE: autovacuum locking question
In-Reply-To: <d5fca64e56a64011afe41a2a44726bda@USEPRDEX1.corp.kns.com>
* 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