Re: Increasing WAL usage followed by sudden drop

Josh Berkus wrote
>
>> We are not doing anything to postgres that would cause the rise and
>> drop.
>> Data base activity is pretty consistent. nor are we doing any kind
>> of
>> purge. This week the drop occurred after 6 days. We are thinking it
>> must
>> be some kind of internal postgres activity but we can't track it
>> down.
>
> Well, we certainly can't figure it out on this list by blind guessing ...
>

Have to agree with you there. Unfortunately this is where we've ended up.
What can we look at and/or show that would help us to narrow it down? Is
there anyway we can look into the wal file and see exactly what is being
sent? I think this might actually give us the most insight.

--
View this message in context: http://postgresql.1045698.n5.nabble.com/Increasing-WAL-usage-followed-by-sudden-drop-tp5719567p5720250.html
Sent from the PostgreSQL - performance mailing list archive at Nabble.com.