Re: [GENERAL] wal archive peak during pg_dump

2014-01-10 Thread Luca Ferrari
On Thu, Jan 9, 2014 at 11:42 AM, Willy-Bas Loos wrote: > 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? Interesti

Re: [GENERAL] wal archive peak during pg_dump

2014-01-09 Thread Michael Paquier
On Thu, Jan 9, 2014 at 7:42 PM, Willy-Bas Loos 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 se