| From: | Robert Haas <robertmhaas(at)gmail(dot)com> |
|---|---|
| To: | searcher s <just(dot)search(dot)go(at)gmail(dot)com> |
| Cc: | "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Full_page_write is off in backup mode |
| Date: | 2014-10-01 14:37:10 |
| Message-ID: | CA+TgmoaJnxLsye947g7j_0y=Xuv8M4dP=9KRJWwVr5jqpuzP9g@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Mon, Sep 29, 2014 at 12:06 PM, searcher s <just(dot)search(dot)go(at)gmail(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Robert Haas | 2014-10-01 14:45:13 | Re: test_shm_mq failing on anole (was: Sending out a request for more buildfarm animals?) |
| Previous Message | Andres Freund | 2014-10-01 14:22:52 | Re: pg_receivexlog and replication slots |