Re: COPY, lock release and MVCC

Поиск
Список
Период
Сортировка
От Laurenz Albe
Тема Re: COPY, lock release and MVCC
Дата
Msg-id 530ec640afd8e76b05ff270602e1f7048f1360e3.camel@cybertec.at
обсуждение исходный текст
Ответ на Re: COPY, lock release and MVCC  (Robert Haas <robertmhaas@gmail.com>)
Ответы Re: COPY, lock release and MVCC  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
On Mon, 2020-05-11 at 15:43 -0400, Robert Haas wrote:
> 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.

Well, should we fix the code or the documentation?

Yours,
Laurenz Albe




В списке pgsql-hackers по дате отправления:

Предыдущее
От: "Jonah H. Harris"
Дата:
Сообщение: Re: Our naming of wait events is a disaster.
Следующее
От: Tom Lane
Дата:
Сообщение: Re: COPY, lock release and MVCC