Hi, On 2014-10-20 21:03:59 +0200, jes...@krogh.cc wrote: > One of our "production issues" is that the system generates lots of > wal-files, lots is like 151952 files over the last 24h, which is about > 2.4TB worth of WAL files. I wouldn't say that isn't an issue by itself, > but the system does indeed work fine. We do subsequently gzip the files to > limit actual disk-usage, this makes the files roughly 30-50% in size.
Have you analyzed what the source of that volume is? Which version of postgres are you using? What's your checkpoint_timeout/segments settings? Greetings, Andres Freund -- Andres Freund http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers