From: | Simon Riggs <simon(at)2ndQuadrant(dot)com> |
---|---|
To: | Wells Oliver <wellsoliver(at)gmail(dot)com> |
Cc: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: Massive insert created 975 WAL segments.. what? |
Date: | 2012-09-12 06:14:04 |
Message-ID: | CA+U5nMKnFhUfAoihNg5rL0HJADy6ZDL0xbTvoymsgTFRSGjyWw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
On 12 September 2012 01:10, Wells Oliver <wellsoliver(at)gmail(dot)com> wrote:
> We were doing a test and inserted 1.5 million rows. In doing so, postgres
> created 974 WAL segments of 16MB apiece. The relevant configuration from my
> master's postgresql.conf:
>
> wal_level = hot_standby
> archive_mode = on
> archive_command = 'test ! -f /mnt/postgresql-logs/%f && cp %p
> /mnt/postgresql-logs/%f'
> max_wal_senders = 3
> wal_keep_segments = 16
>
> So, now I have 16GB of WAL segments, 974 of them. Will postgresql clean this
> up? Will it remove these files? Will it create more with big inserts?
>
> What is the best way to manage this?
These are transaction log files, created by database writes. They
protect you if you crash and also allow replication/backup.
These will be rotated every checkpoint, which by default is 5 minutes.
So they'll be long gone by now.
--
Simon Riggs http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
From | Date | Subject | |
---|---|---|---|
Next Message | Thomas Kellerer | 2012-09-12 09:09:23 | Missing loadable libraries when running pg_upgrade 9.1 -> 9.2 |
Previous Message | Ray Stell | 2012-09-12 01:45:41 | Re: Massive insert created 975 WAL segments.. what? |