pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Rui DeSousa <rui@crazybean.net>
To: MichaelDBA <MichaelDBA@sqlexec.com>
Cc: John Lumby <johnlumby@hotmail.com>
Cc: Simon Riggs <simon@2ndquadrant.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-admin <pgsql-admin@postgresql.org>
Subject: Re: admin control over cancelling autovacuum when blocked by a lock
Date: Tue, 30 Apr 2019 11:10:12 -0400
Message-ID: <1144E125-F9BA-4202-AC01-E3FD09B147FE@crazybean.net> (raw)
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@sqlexec.com> 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.

view thread (15+ messages)  latest in thread

Message-ID: <1144E125-F9BA-4202-AC01-E3FD09B147FE@crazybean.net>
Permalink:  ../1144E125-F9BA-4202-AC01-E3FD09B147FE@crazybean.net/
Also on:    postgresql.org/message-id/1144E125-F9BA-4202-AC01-E3FD09B147FE@crazybean.net

 · 

reply
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: rui@crazybean.net, MichaelDBA@sqlexec.com, johnlumby@hotmail.com, simon@2ndquadrant.com, tgl@sss.pgh.pa.us
  Subject: Re: admin control over cancelling autovacuum when blocked by a lock
  In-Reply-To: <1144E125-F9BA-4202-AC01-E3FD09B147FE@crazybean.net>

* 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