Re: Full_page_write is off in backup mode

Поиск
Список
Период
Сортировка
От Robert Haas
Тема Re: Full_page_write is off in backup mode
Дата
Msg-id CA+TgmoaJnxLsye947g7j_0y=Xuv8M4dP=9KRJWwVr5jqpuzP9g@mail.gmail.com
обсуждение исходный текст
Ответ на Full_page_write is off in backup mode  (searcher s <just.search.go@gmail.com>)
Список pgsql-hackers
On Mon, Sep 29, 2014 at 12:06 PM, searcher s <just.search.go@gmail.com> wrote:
> Hi,
>     I am using postgres 9.2.2.
> The postgresql documentation says, full_page_writes is forcibly on after
> executing the function pg_start_backup. But in my server full_page_writes is
> still off  (not changed).

The value of the GUC doesn't actually change.  But the system still
performs full page writes during the backup.  Search the source code
for forcePageWrites to see how it works internally.

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



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

Предыдущее
От: Andres Freund
Дата:
Сообщение: Re: pg_receivexlog and replication slots
Следующее
От: Robert Haas
Дата:
Сообщение: Re: test_shm_mq failing on anole (was: Sending out a request for more buildfarm animals?)