| From: | John Coers <coers(at)intrinsity(dot)com> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | "Mikheev, Vadim" <vmikheev(at)SECTORBASE(dot)COM>, pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: COPY locking |
| Date: | 2001-05-10 21:30:36 |
| Message-ID: | 3AFB087C.1FBB9C5F@intrinsity.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Tom Lane wrote:
>
> "Mikheev, Vadim" <vmikheev(at)SECTORBASE(dot)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(at)intrinsity(dot)com Austin, Texas
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Chris Jones | 2001-05-10 21:34:18 | Re: Re: Query not using index |
| Previous Message | Tom Lane | 2001-05-10 21:25:04 | Re: formatting a date |