From: | Willy-Bas Loos <willybas(at)gmail(dot)com> |
---|---|
To: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | wal archive peak during pg_dump |
Date: | 2014-01-09 10:46:12 |
Message-ID: | CAHnozTgho9v5enU0Cop2rY5jmg-LXYDviqVLtdbJGo4p2R7eng@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
please excuse my forgetting [GENERAL] in the subject of the other mail.
On Thu, Jan 9, 2014 at 11:42 AM, Willy-Bas Loos <willybas(at)gmail(dot)com> wrote:
> Hi,
>
> I've set up hot standby slaves for a couple of clusters.
> The wal is cleaned up after use, i don't use it as a backup (yet).
> It seems that the amount of wal peaks shortly after midnight, when pg_dump
> is running.
>
> It doesn't seem logical to me that pg_dump should generate wal, but i
> haven't been able to find a different explanation so far.
> So to make sure, i want to ask you people: can it be that running pg_dump
> creates a lot of wal?
>
> Cheers,
>
> WBL
>
> --
> "Quality comes from focus and clarity of purpose" -- Mark Shuttleworth
>
--
"Quality comes from focus and clarity of purpose" -- Mark Shuttleworth
From | Date | Subject | |
---|---|---|---|
Next Message | Marco Baringer | 2014-01-09 11:10:34 | getting domain information from query results |
Previous Message | Willy-Bas Loos | 2014-01-09 10:42:42 | wal archive peak during pg_dump |