Re: Increasing WAL usage followed by sudden drop

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



> Any ideas on any of this? Why the sawteeth? Why the rise-then-drop? 

Well, my first thought on the sawteeth is that you have archive_timeout
set to 15 minutes.  No?

As for the gradual buildup over days, that most likely corresponds to
either changes in application activity levels, or some kind of weekly
data purge cycle which shrinks your database every weekend.  Since I
don't know anything about your admin or your application, that's a best
guess.


-- 
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com


-- 
Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance


[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux