Transaction log size debugging

From: Ted Hahn <ted(at)lifeonair(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Transaction log size debugging
Date: 2017-02-24 20:34:53
Message-ID: CACxPChK4wd3R_N+bCe-hJ+fSOSh3D9p0K6+aMD6NrSs0rK9nUg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Would it be possible for someone more knowledgable to add a summary of
"Finding the size of your transaction log" to
https://wiki.postgresql.org/wiki/Disk_Usage ? I'm new to postgre, and had a
non-trivial debugging session of why our server had low disk space. It
turned out to be a logical replication slot that was no longer in use;
Resulting in a slow growth of the transaction logs that had to hang around.
A note on that wiki page (even just to the effect of "Here's another thing
than can take up disk space") would have been helpful in debugging.

Thanks!
-Ted Hahn

Browse pgsql-admin by date

  From Date Subject
Next Message downey.deng@postgresdata.com 2017-02-27 15:13:54 cpu hight sy% usage
Previous Message Lazaro Garcia 2017-02-24 17:15:48 Re: [pgpool-general: 5345] Failover but master is running