On 2018-Nov-06, Ron wrote:
> On 11/06/2018 05:34 AM, Alvaro Herrera wrote:
> I did see it, but the https://wiki.postgresql.org/wiki/Lock_Monitoring query
> seems to work (seeing that it regularly shows locks).
>
> Is this query from https://stackoverflow.com/a/43363536/1543618 adequate to
> the
On 11/06/2018 05:34 AM, Alvaro Herrera wrote:
On 2018-Nov-05, Ron wrote:
That (plus pg_locks) is the heart of the "list all blocking queries"
statement I copied from https://wiki.postgresql.org/wiki/Lock_Monitoring.
On that page there's a note about 9.6. Did you see the referenced
commit
htt
On 11/06/2018 05:05 AM, Laurenz Albe wrote:
Ron wrote:
However, one or more of our big (and schema-identical) prod databases (which
are each on a different server)
it is finicky and tends to just "sit" at a random one of the CREATE OR REPLACE
FUNCTION statements.
The "list all blocking querie
On 2018-Nov-05, Ron wrote:
> That (plus pg_locks) is the heart of the "list all blocking queries"
> statement I copied from https://wiki.postgresql.org/wiki/Lock_Monitoring.
On that page there's a note about 9.6. Did you see the referenced
commit
https://git.postgresql.org/gitweb/?p=postgresql.
Ron wrote:
> > > However, one or more of our big (and schema-identical) prod databases
> > > (which are each on a different server)
> > > it is finicky and tends to just "sit" at a random one of the CREATE OR
> > > REPLACE FUNCTION statements.
> > >
> > > The "list all blocking queries" I run do
On 11/05/2018 08:30 PM, Rob Sargent wrote:
On 11/5/18 7:05 PM, Ron wrote:
I've got a very puzzling problem on 9.6.6 systems we just migrated from
8.4. (The same problem happened on 9.6.9, but rolled it back so as to
make prod have the same version as our Staging systems.)
We've got a giant
On 11/5/18 7:05 PM, Ron wrote:
I've got a very puzzling problem on 9.6.6 systems we just migrated
from 8.4. (The same problem happened on 9.6.9, but rolled it back so
as to make prod have the same version as our Staging systems.)
We've got a giant script full of DROP TRIGGER IF EXISTS and CR
I've got a very puzzling problem on 9.6.6 systems we just migrated from
8.4. (The same problem happened on 9.6.9, but rolled it back so as to make
prod have the same version as our Staging systems.)
We've got a giant script full of DROP TRIGGER IF EXISTS and CREATE TABLE and
DROP TABLE and CR