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

From Heikki Linnakangas
Subject Re: BUG #7521: Cannot disable WAL log while using pg_dump
Date
Msg-id 504902C7.9030903@iki.fi
Whole thread Raw
In response to Re: BUG #7521: Cannot disable WAL log while using pg_dump  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: BUG #7521: Cannot disable WAL log while using pg_dump  (Robert Haas <robertmhaas@gmail.com>)
Re: BUG #7521: Cannot disable WAL log while using pg_dump  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
On 06.09.2012 13:07, Robert Haas wrote:
> On Thu, Sep 6, 2012 at 3:55 PM, Tom Lane<tgl@sss.pgh.pa.us>  wrote:
>> Robert Haas<robertmhaas@gmail.com>  writes:
>>> On Wed, Sep 5, 2012 at 9:57 AM,<boy@atsc.nl>  wrote:
>>>> So it would be nice if there is an option to disable WAL logging while
>>>> running pg_dump.
>>
>>> pg_dump doesn't modify any data, so I don't see how it could be
>>> causing WAL logs to get generated.
>>
>> Doesn't hint-bit setting cause WAL traffic these days?
>
> I sure as heck don't think so.

It does not. HOT page pruning does, however. It could be that..

- Heikki

pgsql-bugs by date:

Previous
From: Robert Haas
Date:
Subject: Re: BUG #7521: Cannot disable WAL log while using pg_dump
Next
From: Robert Haas
Date:
Subject: Re: BUG #7521: Cannot disable WAL log while using pg_dump