Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nrnqn-0007yn-Rs for pgsql-admin@arkaria.postgresql.org; Thu, 19 May 2022 21:38:29 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1nrnql-0001K4-Uu for pgsql-admin@arkaria.postgresql.org; Thu, 19 May 2022 21:38:27 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nrnql-0001Jv-If for pgsql-admin@lists.postgresql.org; Thu, 19 May 2022 21:38:27 +0000 Received: from mail-ot1-x32c.google.com ([2607:f8b0:4864:20::32c]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1nrnqj-00067i-HA for pgsql-admin@postgresql.org; Thu, 19 May 2022 21:38:27 +0000 Received: by mail-ot1-x32c.google.com with SMTP id y14-20020a9d460e000000b00605ee347da1so4391526ote.8 for ; Thu, 19 May 2022 14:38:25 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20210112; h=mime-version:from:date:message-id:subject:to; bh=MSKe7SsOOXXflN/G1+jnzt40w6XMQiTViwx14AjVeyU=; b=WazANu8W5ot+UouvZj2L4sN9RHkB58O7wQNamGu/VfzyuFqu9PI1bWmnIiqBpzcbCn v59c8ycgbP+X1w55xrxIe0X22OMKxqmZPElulb96AZbn7ZBGylr+SASlQTedFbHcvXbh 4v6g6TqsVBl90FjlmVrE5pRV1Bo64gRorRO0mColXQap3Hy8QHm7IB90ed8E9jsd9fvG kYjlBMFxxy0kjw1SJOoNkPi6BF1VgdbwLubw/h9+Gz5FBayxLOJrl392BW4trd3eAq4i n/XCC9kBWXWslXnWCwZdwpIHZj+2mZeEUzK0lQFmQWXyXFRD9oHeGJZEOONWEiG4ptlk NZuw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=x-gm-message-state:mime-version:from:date:message-id:subject:to; bh=MSKe7SsOOXXflN/G1+jnzt40w6XMQiTViwx14AjVeyU=; b=kK2auD4h0PkVcjif/9uNBjUBfPY4we2QomC8pe23qKfjRpx+MvqDVDCRqp3gCVkEDY aTIpZyo04li6zKv7V9P103oI67VFgJjN+2YVTFUY0xwg2BgNnSzfdUXAN6Cym9NEGbVY 7L3p//1msBAZuUGDbxzI225iagswD0nG5U32vYl9zPf1kZMlCyxSQ326zohFJoXTZiW9 U/xAxlx9whqYiQufhEyZIIt9vrO6v9Ne1omiWnNe2IVwj1zMGCHlaVgixDxXFeujlDVs aBVP35EqHEpg2chhWmjQltsQ8RHjNyT17QlYJ1mioDbBnncf08hJbO4HrJnQ+gSaH6tz dNVQ== X-Gm-Message-State: AOAM532K1UR7j9PmbvVWFNwJlZMsEYdhBDkoIQPxwv/XEVgPHfGRE0xk 71yj1W44bOOP4gYAHcr+pP60OgQhMGxPsiSDKWL0sAqN X-Google-Smtp-Source: ABdhPJyewXUv6Rcye35bvV6S/GkaQH3a8KDq4ldDox+ekPct+wlX1HuGkLWfD+Q6MimmyDenI7iRsDesTPgJd8WuvGk= X-Received: by 2002:a05:6830:1611:b0:606:1382:6758 with SMTP id g17-20020a056830161100b0060613826758mr2823523otr.126.1652996303138; Thu, 19 May 2022 14:38:23 -0700 (PDT) MIME-Version: 1.0 From: Wells Oliver Date: Thu, 19 May 2022 14:37:47 -0700 Message-ID: Subject: Locks under the hood on re-mat and dropping triggers To: pgsql-admin Content-Type: multipart/alternative; boundary="00000000000076b37405df6431ec" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --00000000000076b37405df6431ec Content-Type: text/plain; charset="UTF-8" Dropping triggers from some table yields a lock while a concurrent refresh of a materialized view in another schema entirely is running-- why is this? -- Wells Oliver wells.oliver@gmail.com --00000000000076b37405df6431ec Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Dropping triggers from some table yields a lock while a co= ncurrent refresh of a materialized view in another schema entirely is runni= ng-- why is this?

--
--00000000000076b37405df6431ec--