Postgres Pro
Downloads
Home   >   mailing lists

Re: COPY, lock release and MVCC - Mailing list pgsql-hackers

From Robert Haas
Subject Re: COPY, lock release and MVCC
Date
Msg-id CA+TgmoYYTBXu_Jh=-B5yS++5t=LXT_7N=Ab3T21Z87TZ5ndGGQ@mail.gmail.com
Whole thread Raw
In response to COPY, lock release and MVCC  (Laurenz Albe <laurenz.albe@cybertec.at>)
Responses Re: COPY, lock release and MVCC
List pgsql-hackers
Tree view 
On Fri, May 8, 2020 at 4:58 AM Laurenz Albe <laurenz.albe@cybertec.at> wrote:
> I happened to notice that COPY TO releases the ACCESS SHARE lock
> on the table right when the command ends rather than holding it
> until the end of the transaction:

That seems inconsistent with what an INSERT statement would do, and thus bad.

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: No core file generated after PostgresNode->start
Next
From: Julien Rouhaud
Date:
Subject: Re: Add "-Wimplicit-fallthrough" to default flags (was Re: pgsql:Support FETCH FIRST WITH TIES)