Re: pg_relation_size locking

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