<div dir="ltr">Of particular interest is<div><br></div><div><div>-rw------- 1 postgres postgres 94479 Dec 2 21:29 postgresql-Fri.log</div><div>-rw------- 1 postgres postgres 0 Dec 5 00:00 postgresql-Mon.log</div><div>-rw------- 1 postgres postgres 0 Dec 3 00:00 postgresql-Sat.log</div><div>-rw------- 1 postgres postgres 0 Dec 4 00:00 postgresql-Sun.log</div><div>-rw------- 1 postgres postgres 208184 Dec 1 23:59 postgresql-Thu.log</div><div>-rw------- 1 postgres postgres 86154 Nov 29 21:57 postgresql-Tue.log</div><div>-rw------- 1 postgres postgres 89399 Nov 30 21:48 postgresql-Wed.log</div></div><div><br></div><div>Huh - want to bet the writes were actually on thursday? The plot thickens!</div></div><div class="gmail_extra"><br><div class="gmail_quote">On Mon, Dec 5, 2016 at 7:43 AM, Mike Bean <span dir="ltr"><<a href="mailto:beandaemon@gmail.com" target="_blank">beandaemon@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr"><br><div>Do we have members who are comfortable/skilled with postgres? Long story short we have a spacewalk server running postgres and the DB is showing really erratic behavior. We used to do weekly vacuums to keep it from running out of space, I figured out that doing a reindex bumped the free space from 20-80 GB. Over the weekend, it dropped to roughly 60, we went one week without doing a vacuum reindex, and it's back down to 20.</div><div><br></div><div>I know for a fact there's no one else in the organization making major changes on this DB, and certainly nothing that could justify 40GB of writes in 3 days. Not really being a DBA, I'm running low on my bag of tricks, thought I'd see if CLUE had any advice. Running vacuums once a week to keep it from filling the disk feels like taking aspirin to get over your gunshot wound. Sure, it'll keep the server running, but ultimately what I really want to know is why a largely static spacewalk DB is writing 60GB to the disk in a 2 week interval.</div><div><br></div></div>
</blockquote></div><br></div>