Re: admin control over cancelling autovacuum when blocked by a lock

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

To: MichaelDBA <MichaelDBA@xxxxxxxxxxx>
Subject: Re: admin control over cancelling autovacuum when blocked by a lock
From: Rui DeSousa <rui@xxxxxxxxxxxxx>
Date: Tue, 30 Apr 2019 11:10:12 -0400
Cc: John Lumby <johnlumby@xxxxxxxxxxx>, Simon Riggs <simon@xxxxxxxxxxxxxxx>, Tom Lane <tgl@xxxxxxxxxxxxx>, pgsql-admin <pgsql-admin@xxxxxxxxxxxxxx>
In-reply-to: <3ed07258-724a-b8e7-9af3-6a07d39d7aa4@sqlexec.com>
References: <DM6PR06MB556272F9CB7629B10CE86829A3390@DM6PR06MB5562.namprd06.prod.outlook.com> <CANP8+jJSysBHF_QRdYmT-iKQDy4yw8OaqgiLoNJPdjTX1bJB8w@mail.gmail.com> <DM6PR06MB556216D6085FE0B9C267E82CA33A0@DM6PR06MB5562.namprd06.prod.outlook.com> <19835.1556588662@sss.pgh.pa.us> <CANP8+j+yBChxtUPriLttV=orwdF7RWtpP+zjF_fCB2yscuJz=g@mail.gmail.com> <DM6PR06MB55628354552B06395479033BA33A0@DM6PR06MB5562.namprd06.prod.outlook.com> <ACF14079-4541-4300-978C-BEC42339B33F@crazybean.net> <3ed07258-724a-b8e7-9af3-6a07d39d7aa4@sqlexec.com>

On Apr 30, 2019, at 11:04 AM, MichaelDBA <MichaelDBA@xxxxxxxxxxx> wrote:

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

Hmm, haven’t seen auto vacuum block; but I believe auto vacuum freeze is still a blocking event.

References:
- admin control over cancelling autovacuum when blocked by a lock
  - From: John Lumby
- Re: admin control over cancelling autovacuum when blocked by a lock
  - From: Simon Riggs
- Re: admin control over cancelling autovacuum when blocked by a lock
  - From: John Lumby
- Re: admin control over cancelling autovacuum when blocked by a lock
  - From: Tom Lane
- Re: admin control over cancelling autovacuum when blocked by a lock
  - From: Simon Riggs
- Re: admin control over cancelling autovacuum when blocked by a lock
  - From: John Lumby
- Re: admin control over cancelling autovacuum when blocked by a lock
  - From: Rui DeSousa
- Re: admin control over cancelling autovacuum when blocked by a lock
  - From: MichaelDBA

Prev by Date: Re: admin control over cancelling autovacuum when blocked by a lock
Next by Date: Re: admin control over cancelling autovacuum when blocked by a lock
Previous by thread: Re: admin control over cancelling autovacuum when blocked by a lock
Next by thread: Re: admin control over cancelling autovacuum when blocked by a lock
Index(es):
- Date
- Thread

[Index of Archives] [KVM ARM] [KVM ia64] [KVM ppc] [Virtualization Tools] [Spice Development] [Libvirt] [Libvirt Users] [Linux USB Devel] [Linux Audio Users] [Yosemite Questions] [Linux Kernel] [Linux SCSI] [XFree86]