From: | Martin Bruset Solberg <martin(dot)bruset(dot)solberg(at)gmail(dot)com> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | pg_xlog filling up under load |
Date: | 2015-02-02 16:55:28 |
Message-ID: | CA+Cf-b_rG6V-F=NDbBety2RxT1hZvu2xMXFj7N1Uz4cTrZBgDA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
I have a database set up with streaming replication over two nodes, and use
repmgr for managing the setup. As per repmgr instructions, I have set
keep_wal_segments to 5000, resulting in about 80GB of WAL files in pg_xlog.
I've set up pg_xlog on it's own 100GB volume.
Mostly, the disk space used by the WAL files are a constant 80GB, with the
files rotating out as new ones are written. This is how I understand it's
supposed to work. However, on a couple of occasions, the total disk usage
on the pg_xlog volume has grown, and filled up the available space (with
the predictable consequences). This seems to have happened under periods of
heavy IO load on the underlying disk system.
The Postgres cluster is spread out over different volumes, but all the
volumes are on the same SAN, so heavy load on one volume is heavy load on
all the volumes. Am I right in suspecting that IO bottleneck is the cause
of WAL files expanding over the keep_wal_segments value, or are there
circumstances where the WAL might actually grow over the set value?
From | Date | Subject | |
---|---|---|---|
Next Message | Craig James | 2015-02-02 19:12:57 | Re: dropping all databases and starting afresh |
Previous Message | Zoltan Szecsei | 2015-02-02 16:52:12 | dropping all databases and starting afresh |