Re: Locks under the hood on re-mat and dropping triggers - Mailing list pgsql-admin

From Tom Lane
Subject Re: Locks under the hood on re-mat and dropping triggers
Date
Msg-id 489128.1653079274@sss.pgh.pa.us
Whole thread Raw
In response to Re: Locks under the hood on re-mat and dropping triggers  (Wells Oliver <wells.oliver@gmail.com>)
List pgsql-admin
Wells Oliver <wells.oliver@gmail.com> writes:
> but what I am seeing is this lock even when the trigger and table are not
> at all used by an entirely separate mat-view being re-materialized.

You'd need to show a test case.  Personally I'm wondering if there's a
foreign key constraint connecting the troublesome table to some table
used by the matview.

            regards, tom lane



pgsql-admin by date:

Previous
From: Ron
Date:
Subject: Re: Many databases ou many schemas
Next
From: aditya desai
Date:
Subject: Re: Steps to Install archived Postgres 9.3 and 9.6