lock mode for ControlFileLock which pg_start_backup uses

Поиск
Список
Период
Сортировка
От Fujii Masao
Тема lock mode for ControlFileLock which pg_start_backup uses
Дата
Msg-id 3f0b79eb1003081733j33223935he59f015162a21a51@mail.gmail.com
обсуждение исходный текст
Ответы Re: lock mode for ControlFileLock which pg_start_backup uses  (Takahiro Itagaki <itagaki.takahiro@oss.ntt.co.jp>)
Re: lock mode for ControlFileLock which pg_start_backup uses  (Takahiro Itagaki <itagaki.takahiro@oss.ntt.co.jp>)
Список pgsql-hackers
Hi,

Currently pg_start_backup() accesses the shared ControlFile
by using ControlFileLock with LW_EXCLUSIVE lock mode. But
since that access is read-only operation, LW_SHARED should
be chosen instead of LW_EXCLUSIVE.

The attached patch changes the lock mode which pg_start_backup()
uses. Is it worth applying this patch?

Regards,

--
Fujii Masao
NIPPON TELEGRAPH AND TELEPHONE CORPORATION
NTT Open Source Software Center

Вложения

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

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: Re: incorrect exit code from psql with single transaction + violation of deferred FK constraint
Следующее
От: Andrew Dunstan
Дата:
Сообщение: Re: invalid UTF-8 via pl/perl