FAQ

Jim Mercer writes:
i had several concurrent processes which would do inserts via COPY and
queries.
on that system, i don't recall the COPY processes as being blocked by the
query processes.
now i'm running that app on solaris 7 with pgsql 7.0.
i'm finding that a big long select is blocking other processes which
are doing COPY's.
Hmm. In 7.0, COPY IN acquires an exclusive lock on the target table,
which is something I put in in a fit of paranoia. It may not really
be necessary --- probably a regular write lock would be good enough.
OK, fix committed. Jim, if you're in a hurry for this fix, just change
AccessExclusiveLock to RowExclusiveLock at line 289 of
backend/commands/copy.c.

regards, tom lane

Search Discussions

Discussion Posts

Previous

Follow ups

Related Discussions

Discussion Navigation
viewthread | post
posts ‹ prev | 6 of 8 | next ›
Discussion Overview
grouppgsql-hackers @
categoriespostgresql
postedMay 17, '00 at 11:45p
activeMay 18, '00 at 2:33a
posts8
users4
websitepostgresql.org...
irc#postgresql

People

Translate

site design / logo © 2021 Grokbase