Received: from makus.postgresql.org ([98.129.198.125])
	by malur.postgresql.org with esmtp (Exim 4.72)
	(envelope-from <stellr@vt.edu>) id 1TBc1W-0007a3-5L
	for pgsql-admin@postgresql.org; Wed, 12 Sep 2012 01:45:50 +0000
Received: from lennier.cc.vt.edu ([198.82.162.213])
	by makus.postgresql.org with esmtp (Exim 4.72)
	(envelope-from <stellr@vt.edu>) id 1TBc1U-0003pv-5N
	for pgsql-admin@postgresql.org; Wed, 12 Sep 2012 01:45:48 +0000
Received: from steiner.cc.vt.edu (steiner.cc.vt.edu [198.82.163.51])
	by lennier.cc.vt.edu (8.13.8/8.13.8) with ESMTP id q8C1jk9E022737
	for <pgsql-admin@postgresql.org>; Tue, 11 Sep 2012 21:45:46 -0400
Received: from mail-qa0-f72.google.com (EHLO mail-qa0-f72.google.com)
	([209.85.216.72]) by steiner.cc.vt.edu (MOS 4.3.3-GA FastPath queued)
	with ESMTP id UAI49381; Tue, 11 Sep 2012 21:45:46 -0400 (EDT)
Received: by qaas11 with SMTP id s11so1845423qaa.7
	for <pgsql-admin@postgresql.org>; Tue, 11 Sep 2012 18:45:46 -0700 (PDT)
X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
	d=google.com; s=20120113;
	h=subject:mime-version:content-type:from:in-reply-to:date:cc
	:content-transfer-encoding:message-id:references:to:x-mailer
	:x-gm-message-state;
	bh=twzsJEKQ2nSKMd+kURi8VUOiePWeG0sR9VU4Vq1uSeE=;
	b=ftZmNbFHX7bL8yEC0fiWVkLBav6c+w+Q4VqQA03AFWeufJXfdsCmAxBOHVbGONWqVh
	MMEyhiKq2AgBbVx/U88Wnb95p5+d5OYVhqbNVIgmCd7VF7wM3bkmB8RnaHLMmPXmM4W9
	iBdCUAqha2CBkurF5BgdZuDpD+E24koq27G1x5snblOexgqI38ph5Z8GlJnU69wiHhZq
	JsxZ/mwdf46QUAdk7hixY6ka31KQGYzvJlwAh0M/1CwZqpDZ3DeNWOlfv0DTqnknuX3/
	+bJlWV0wOPLLAosvPUxqPAN3YqZsEWV04sWC2MnHCb8Fjui450ZsKnBq4OYwF+KBjwPd
	WWqw==
Received: by 10.229.135.76 with SMTP id m12mr5511990qct.68.1347414345774;
	Tue, 11 Sep 2012 18:45:45 -0700 (PDT)
Received: by 10.229.135.76 with SMTP id m12mr5511983qct.68.1347414345373;
	Tue, 11 Sep 2012 18:45:45 -0700 (PDT)
Received: from [192.168.2.3] (pool-72-66-201-4.ronkva.east.verizon.net.
	[72.66.201.4])
	by mx.google.com with ESMTPS id gx4sm8235292qab.3.2012.09.11.18.45.43
	(version=TLSv1/SSLv3 cipher=OTHER);
	Tue, 11 Sep 2012 18:45:44 -0700 (PDT)
Subject: Re: Massive insert created 975 WAL segments.. what?
Mime-Version: 1.0 (Apple Message framework v1278)
Content-Type: text/plain; charset=iso-8859-1
From: Ray Stell <stellr@vt.edu>
In-Reply-To: 
 <CAOC+FBXHz7uGwFgO+WNMWabx_zgqyA8UvdPgNhSCkHojR0LrOQ@mail.gmail.com>
Date: Tue, 11 Sep 2012 21:45:41 -0400
Cc: pgsql-admin@postgresql.org
Content-Transfer-Encoding: quoted-printable
Message-Id: <702E8E72-E666-4870-B7F2-0B8FAC0781BC@gmail.com>
References: 
 <CAOC+FBXHz7uGwFgO+WNMWabx_zgqyA8UvdPgNhSCkHojR0LrOQ@mail.gmail.com>
To: Wells Oliver <wellsoliver@gmail.com>
X-Mailer: Apple Mail (2.1278)
X-Gm-Message-State: 
 ALoCoQmU82UYJcqFdJX293cob355Y5x/IYDibkDuq0EeXHiIv7M3tEpZE0QtkxHI8Sg8pLWCqWOUPRtt+ZSkLB7fqsGtKJG2nJM7wM82JbQSzXY+b3Gs2FPaFpUaCOzpmhdoGB+2RU1XgHHrASOv5FAZTDyXAKlfgZhV9OhEM1kEITrD+/hyF58=
X-Mirapoint-Received-SPF: 209.85.216.72 mail-qa0-f72.google.com stellr@vt.edu
	4 softfail
X-Junkmail-Status: score=10/50, host=steiner.cc.vt.edu
X-Junkmail-Signature-Raw: score=unknown,
	refid=str=0001.0A020209.504FE94A.0046,ss=1,re=0.000,fgs=0,
	ip=0.0.0.0, so=2011-07-25 19:15:43,
	dmn=2011-05-27 18:58:46, mode=single engine
X-Junkmail-IWF: false
X-Pg-Spam-Score: -3.0 (---)
X-Archive-Number: 201209/49
X-Sequence-Number: 39990


On Sep 11, 2012, at 8:10 PM, Wells Oliver wrote:

> 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?
>=20
> What is the best way to manage this?

http://www.postgresql.org/docs/9.2/static/pgarchivecleanup.html

you can use this in conjunction with your backup facility/scipts.  Don't =
want to clean them up until you have a backup, right?=