public inbox for [email protected]  

help / color / mirror / Atom feed

From: Jeff Janes <[email protected]>
To: Niels Kristian Schjødt <[email protected]>
Cc: [email protected] list <[email protected]>
Subject: Re: pg_xlog dir not getting swept
Date: Wed, 29 Jun 2016 12:19:50 -0700
Message-ID: <CAMkU=1xGbK9kOBjH9PEHYK1HZvAO8q53r6HGGMC=8Hg+PLg54Q@mail.gmail.com> (raw)
In-Reply-To: <[email protected]>
References: <[email protected]>
List-Unsubscribe:  <mailto:[email protected]?body=unsub%20pgsql-performance>

On Wed, Jun 29, 2016 at 3:00 AM, Niels Kristian Schjødt
<[email protected]> wrote:
> About a day ago, there seems to have been some trouble in the network of my
> database (postgresql 9.3).
>
> I’m running my db with a streaming replication setup with wall shipping.
>
> I sync wal logs to a mounted networkdrive using archive_command = 'rsync -a
> %p /mnt/wal_drive/wals/%f </dev/null’. Somehow this command was failing,
> leading to my pg_xlog dir building up (590Gb). I rebooted the server, and
> the archiving command seems to succeed now - however - After about an hour
> of running, the pg_xlog drive has not decreased in size - I would have
> expect that! I can see that lot’s of files get’s synced to the
> /mnt/wal_drive/wals dir, but somehow the pg_xlog dir is not swept (yet)?
> Will this happen automatically eventually, or do I need to do something
> manually?

Successfully archived files are only removed by the checkpointer.  The
logic is quite complex and it can be very frustrating trying to
predict exactly when any given file will get removed.  You might want
to run a few manual checkpoints to see if that cleans it up.  But turn
on log_checkpoints and reload the configuration first.

Cheers,

Jeff


-- 
Sent via pgsql-performance mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected]
  Subject: Re: pg_xlog dir not getting swept
  In-Reply-To: <CAMkU=1xGbK9kOBjH9PEHYK1HZvAO8q53r6HGGMC=8Hg+PLg54Q@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox