[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