Re: COPY locking - Mailing list pgsql-general

From John Coers
Subject Re: COPY locking
Date
Msg-id 3AFB087C.1FBB9C5F@intrinsity.com
Whole thread Raw
In response to RE: COPY locking  ("Mikheev, Vadim" <vmikheev@SECTORBASE.COM>)
List pgsql-general
Tom Lane wrote:
>
> "Mikheev, Vadim" <vmikheev@SECTORBASE.COM> writes:
> > access/heap/hio.c:RelationGetBufferForRelation() uses LockPage
> > (ie lmgr -> semops) to syncronize table extending.
>
> But no semop should occur unless somebody is actually blocking on
> the lock.  John's trace only showed one active backend, so I figured
> that there shouldn't be any blockage.

Keep in mind that I only sent a sample of trace data to show the kind of
things I was seeing, not the entire process from end-to-end.

--
John Coers            Intrinsity, Inc.
coers@intrinsity.com  Austin, Texas

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Re: Query not using index
Next
From: "Mikheev, Vadim"
Date:
Subject: RE: COPY locking