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

help / color / mirror / Atom feed
From: Rui DeSousa <rui@crazybean.net>
To: 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 10:12:11 -0400
Message-ID: <ACF14079-4541-4300-978C-BEC42339B33F@crazybean.net> (raw)
In-Reply-To: <DM6PR06MB55628354552B06395479033BA33A0@DM6PR06MB5562.namprd06.prod.outlook.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>



> On Apr 30, 2019, at 9:27 AM, John Lumby <johnlumby@hotmail.com> wrote:
> 
>  it does do ANALYZE  -  in this context is that "DDL"?

I would consider that DDL and the application should avoid doing it; otherwise, you end up with blocking issues where both readers and writers are blocked unnecessarily.  The application issuing analyze on its own temp tables is fine and non blocking.  If you must analyze tables then I would limit which processes have access to those tables to avoid blocking issues.

I would look at your auto vacuum/analyze settings as oppose to the application issuing analyze commands as those are going to be a non blocking option.

view thread (15+ messages)  latest in thread

Message-ID: <ACF14079-4541-4300-978C-BEC42339B33F@crazybean.net>
Permalink:  ../ACF14079-4541-4300-978C-BEC42339B33F@crazybean.net/
Also on:    postgresql.org/message-id/ACF14079-4541-4300-978C-BEC42339B33F@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, 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: <ACF14079-4541-4300-978C-BEC42339B33F@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