Re: BUG #7521: Cannot disable WAL log while using pg_dump - Mailing list pgsql-bugs

From Pavan Deolasee
Subject Re: BUG #7521: Cannot disable WAL log while using pg_dump
Date
Msg-id CABOikdN-jGtEg=LVUTL8Jxjs0xqgHCPLASKEZ3NmgaRTC+xNXw@mail.gmail.com
Whole thread Raw
In response to Re: BUG #7521: Cannot disable WAL log while using pg_dump  (Gezeala M. Bacuño II <gezeala@gmail.com>)
List pgsql-bugs
On Fri, Sep 7, 2012 at 12:15 PM, Gezeala M. Bacu=F1o II <gezeala@gmail.com>=
wrote:


>  The instance is cloned solely for
> backup purposes with zero modifications and autovacuum disabled.
>

For your restricted use case, it might be worthwhile to
turn full_page_writes OFF before starting the server. That should
definitely reduce a lot of WAL volume.

Thanks,
Pavan

pgsql-bugs by date:

Previous
From: Pavan Deolasee
Date:
Subject: Re: BUG #7521: Cannot disable WAL log while using pg_dump
Next
From: Gezeala M. Bacuño II
Date:
Subject: Re: BUG #7521: Cannot disable WAL log while using pg_dump