On Fri, May 8, 2020 at 4:58 AM Laurenz Albe <laurenz.a...@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