Re: pg_relation_size locking - Mailing list pgsql-hackers

From Tom Lane
Subject Re: pg_relation_size locking
Date
Msg-id 2297.1134402304@sss.pgh.pa.us
Whole thread Raw
In response to Re: pg_relation_size locking  (Andreas Pflug <pgadmin@pse-consulting.de>)
Responses Re: pg_relation_size locking  (Andreas Pflug <pgadmin@pse-consulting.de>)
List pgsql-hackers
Andreas Pflug <pgadmin@pse-consulting.de> writes:
> Tom Lane wrote:
>> Nonsense.

> Ahem.

> I'm running Slony against a big replication set. While slon runs COPY 
> foo(colnamelist) FROM STDIN, I can't execute pg_relation_size(foo_oid). 
> pg_locks will show that the AccessShareLock on foo is not granted.

That's only possible if Slony is taking AccessExclusive lock; if so,
your gripe is properly directed to the Slony folks, not to
pg_relation_size which is acting as a good database citizen should.
Certainly a plain COPY command does not take AccessExclusive.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Andreas Pflug
Date:
Subject: Re: pg_relation_size locking
Next
From: Andreas Pflug
Date:
Subject: Re: pg_relation_size locking