<html><body><div style="font-family: Arial; font-size: 12pt; color: #000000"><div aria-label="Compose body">Hi Mike,<br></div><div aria-label="Compose body"><br></div><div aria-label="Compose body"> I don't have any experience specifically with postgres, but this behavior makes me wonder if something might have happened that affects a daemon's ability to access resources... If I was looking into it, I might start by checking whether or not a service account's password has expired, or if an interface has gone down, etc.<br><br>Sorry that I'm not able to be more specific, but hopefully this will be at least marginally helpful...<br></div><div aria-label="Compose body"><br></div><div>T.<br></div><hr id="zwchr"><div style="color:#000;font-weight:normal;font-style:normal;text-decoration:none;font-family:Helvetica,Arial,sans-serif;font-size:12pt;" data-mce-style="color: #000; font-weight: normal; font-style: normal; text-decoration: none; font-family: Helvetica,Arial,sans-serif; font-size: 12pt;"><b>From: </b>"Mike Bean" <beandaemon@gmail.com><br><b>To: </b>"CLUE's mailing list" <clue@cluedenver.org><br><b>Sent: </b>Monday, December 5, 2016 7:47:07 AM<br><b>Subject: </b>Re: [clue] postgres questions?<br><div><br></div><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" data-mce-href="mailto:beandaemon@gmail.com">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" data-mce-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><br>_______________________________________________<br>clue mailing list: clue@cluedenver.org<br>For information, account preferences, or to unsubscribe see:<br>http://cluedenver.org/mailman/listinfo/clue</div><div><br></div></div></body></html>