[clue] postgres questions?
Mike Bean
beandaemon at gmail.com
Mon Dec 5 07:47:07 MST 2016
Of particular interest is
-rw------- 1 postgres postgres 94479 Dec 2 21:29 postgresql-Fri.log
-rw------- 1 postgres postgres 0 Dec 5 00:00 postgresql-Mon.log
-rw------- 1 postgres postgres 0 Dec 3 00:00 postgresql-Sat.log
-rw------- 1 postgres postgres 0 Dec 4 00:00 postgresql-Sun.log
-rw------- 1 postgres postgres 208184 Dec 1 23:59 postgresql-Thu.log
-rw------- 1 postgres postgres 86154 Nov 29 21:57 postgresql-Tue.log
-rw------- 1 postgres postgres 89399 Nov 30 21:48 postgresql-Wed.log
Huh - want to bet the writes were actually on thursday? The plot
thickens!
On Mon, Dec 5, 2016 at 7:43 AM, Mike Bean <beandaemon at gmail.com> wrote:
>
> 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.
>
> 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.
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://cluedenver.org/pipermail/clue/attachments/20161205/cec42e88/attachment.html
More information about the clue
mailing list