Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hLUOi-0002e5-9r for pgsql-admin@arkaria.postgresql.org; Tue, 30 Apr 2019 15:10:20 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1hLUOg-0005Q8-Pk for pgsql-admin@arkaria.postgresql.org; Tue, 30 Apr 2019 15:10:18 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hLUOg-0005MY-B4 for pgsql-admin@lists.postgresql.org; Tue, 30 Apr 2019 15:10:18 +0000 Received: from impout003aa.msg.chrl.nc.charter.net ([47.43.20.27] helo=impout003.msg.chrl.nc.charter.net) by makus.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1hLUOc-00026C-V3 for pgsql-admin@postgresql.org; Tue, 30 Apr 2019 15:10:17 +0000 Received: from cerberus.crazybean.net ([24.151.10.150]) by cmsmtp with ESMTP id LUObhKBM0nJPnLUObhocIp; Tue, 30 Apr 2019 15:10:13 +0000 Authentication-Results: crazybean.net; none X-Authority-Analysis: v=2.3 cv=aafVYigt c=1 sm=1 tr=0 a=D2HTw/M6/8MmcHighGO7rg==:117 a=D2HTw/M6/8MmcHighGO7rg==:17 a=jpOVt7BSZ2e4Z31A5e1TngXxSK0=:19 a=xqWC_Br6kY4A:10 a=oexKYjalfGEA:10 a=j-sDTZhuAAAA:8 a=V4fIR3NPranqIfnWe2cA:9 a=QEXdDO2ut3YA:10 a=WB4hR-TN2FgA:10 a=jSCl6V9HW7F64ARTfF0A:9 a=GK8KO102uRTl6Al4:21 a=_W_S_7VecoQA:10 a=2exvZNYGzqvuYYFq4a2y:22 Received: from [IPv6:2001:470:e117:4:8c6b:d27f:4211:fbca] (2001:470:e117:4:8c6b:d27f:4211:fbca [IPv6:2001:470:e117:4:8c6b:d27f:4211:fbca]) by cerberus.crazybean.net (OpenSMTPD) with ESMTPSA id 60c7affa (TLSv1.2:ECDHE-RSA-AES256-GCM-SHA384:256:NO); Tue, 30 Apr 2019 11:10:13 -0400 (EDT) From: Rui DeSousa Message-Id: <1144E125-F9BA-4202-AC01-E3FD09B147FE@crazybean.net> Content-Type: multipart/alternative; boundary="Apple-Mail=_0E1842F2-2CC7-4A83-9CD2-E2F82651FE9F" Mime-Version: 1.0 (Mac OS X Mail 12.4 \(3445.104.8\)) Subject: Re: admin control over cancelling autovacuum when blocked by a lock Date: Tue, 30 Apr 2019 11:10:12 -0400 In-Reply-To: <3ed07258-724a-b8e7-9af3-6a07d39d7aa4@sqlexec.com> Cc: John Lumby , Simon Riggs , Tom Lane , pgsql-admin To: MichaelDBA References: <19835.1556588662@sss.pgh.pa.us> <3ed07258-724a-b8e7-9af3-6a07d39d7aa4@sqlexec.com> X-Mailer: Apple Mail (2.3445.104.8) X-CMAE-Envelope: MS4wfL4GGgepfUomsn3sxy+iThz9ommnZq4Gb8gH+ruEqXCEft+nT9LJv/xOO0w87fCAcLio/A7pPTYkFi8OTQpMngKHJKiNEE2NHnrsHf7k0YnplcnbO1cL 1XqW5dLB8uuny9c5snek4AigM33OGviucxNlSRQqILn/VMbQIKXHg0OO1/nSFjwMcfDRpc2zEHRNXOX/wtTjjDLj6PM88rk20yIo+SQFqcPRcKilapDYBp6k FCRvHwghZQCdSvUszuAmILc1UCkbrTFyr0SC9zg3EZWTvtEYloY8j23oofvGqYqvIkGTDiRx5Whpjc2BZlNS7Q== List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --Apple-Mail=_0E1842F2-2CC7-4A83-9CD2-E2F82651FE9F Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=utf-8 > On Apr 30, 2019, at 11:04 AM, MichaelDBA = wrote: >=20 > it used to be "in the old days" that autovacuum processes acted like = primary ones blocking user requests. Hmm, haven=E2=80=99t seen auto vacuum block; but I believe auto vacuum = freeze is still a blocking event. --Apple-Mail=_0E1842F2-2CC7-4A83-9CD2-E2F82651FE9F Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=utf-8

On Apr 30, 2019, at 11:04 AM, MichaelDBA <MichaelDBA@sqlexec.com> wrote:

 it used to = be "in the old days" that autovacuum processes acted like primary ones = blocking user requests.

Hmm, haven=E2=80=99t seen auto vacuum block; but I believe = auto vacuum freeze is still a blocking event.

= --Apple-Mail=_0E1842F2-2CC7-4A83-9CD2-E2F82651FE9F--