Re: COPY, lock release and MVCC

Поиск
Список
Период
Сортировка
От Robert Haas
Тема Re: COPY, lock release and MVCC
Дата
Msg-id CA+TgmoYYTBXu_Jh=-B5yS++5t=LXT_7N=Ab3T21Z87TZ5ndGGQ@mail.gmail.com
обсуждение исходный текст
Ответ на COPY, lock release and MVCC  (Laurenz Albe <laurenz.albe@cybertec.at>)
Ответы Re: COPY, lock release and MVCC
Список pgsql-hackers
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 по дате отправления: