Skip site navigation (1) Skip section navigation (2)

Massive insert created 975 WAL segments.. what?

From: Wells Oliver <wellsoliver(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Massive insert created 975 WAL segments.. what?
Date: 2012-09-12 00:10:28
Message-ID: CAOC+FBXHz7uGwFgO+WNMWabx_zgqyA8UvdPgNhSCkHojR0LrOQ@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-admin
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?

-- 
Wells Oliver
wellsoliver(at)gmail(dot)com

Responses

pgsql-admin by date

Next:From: Ray StellDate: 2012-09-12 01:45:41
Subject: Re: Massive insert created 975 WAL segments.. what?
Previous:From: Wells OliverDate: 2012-09-12 00:00:00
Subject:

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group