Received: from maia.hub.org (maia-3.hub.org [200.46.204.243])
	by mail.postgresql.org (Postfix) with ESMTP id 2E59C1337999
	for <pgsql-admin-postgresql.org@mail.postgresql.org>;
	Thu, 31 Mar 2011 23:36:02 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia,
	port 10024) with ESMTP id 38948-09 for
	<pgsql-admin-postgresql.org@mail.postgresql.org>;
	Fri,  1 Apr 2011 02:35:54 +0000 (UTC)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from tamriel.snowman.net (tamriel.snowman.net [72.66.115.51])
	by mail.postgresql.org (Postfix) with ESMTP id 988F013364DE
	for <pgsql-admin@postgresql.org>; Thu, 31 Mar 2011 23:35:54 -0300 (ADT)
Received: by tamriel.snowman.net (Postfix, from userid 1000)
	id 30CAE2299E; Thu, 31 Mar 2011 22:35:55 -0400 (EDT)
Date: Thu, 31 Mar 2011 22:35:55 -0400
From: Stephen Frost <sfrost@snowman.net>
To: Selva manickaraja <mavles78@gmail.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: Too many WAL(s) despite low transaction
Message-ID: <20110401023555.GE4116@tamriel.snowman.net>
References: <AANLkTi=Vc91VMA1_w3e6yV0gmAL1xgbogj9p1fW3zmQ=@mail.gmail.com>
	<20110401004240.GA4116@tamriel.snowman.net>
	<AANLkTik9S-bB0nhAzUWED0vKS_JgF3RkZd0JPNq-C-Yn@mail.gmail.com>
	<20110401010336.GB4116@tamriel.snowman.net>
	<AANLkTi=U_2opbk3Kg223=++V9EfK5KGw-M-28Ec0dxCe@mail.gmail.com>
	<20110401013853.GC4116@tamriel.snowman.net>
	<AANLkTini7zev+CyTLMGFFsaZucxCR35rBsgg_Znj8F-7@mail.gmail.com>
	<20110401022209.GD4116@tamriel.snowman.net>
	<AANLkTinoAVz9qH=fV=qNxMyZnzBXsweDgGK4hQCEebZr@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha1;
	protocol="application/pgp-signature"; boundary="EiEtkL13vkX+L2A+"
Content-Disposition: inline
In-Reply-To: <AANLkTinoAVz9qH=fV=qNxMyZnzBXsweDgGK4hQCEebZr@mail.gmail.com>
X-Editor: Vim http://www.vim.org/
X-Info: http://www.snowman.net
X-Operating-System: Linux/2.6.32-5-amd64 (x86_64)
X-Uptime: 22:33:45 up 57 days, 11:03, 12 users,  load average: 0.00, 0.02,
 0.00
User-Agent: Mutt/1.5.20 (2009-06-14)
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-1.91 tagged_above=-10 required=5 tests=BAYES_00=-1.9,
	T_RP_MATCHES_RCVD=-0.01
X-Spam-Level: 
X-Archive-Number: 201103/309
X-Sequence-Number: 37181


--EiEtkL13vkX+L2A+
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline

* Selva manickaraja (mavles78@gmail.com) wrote:
> Where you mentioned "after the reload" I suppose you meant restart right?

I'm not sure offhand if it requires a reload or a restart, that's why I
suggested doing a reload than then checking the logs to see if a restart
is required.

> About compressing you mentioned iirc, but how do I use it? are there any
> examples. I read about pg_compress before. Is that same?

No, I meant "use gzip".

> The configuration file shows that autovacuum=on and track_count=on to be
> commented out. That means that it is not running right? If that's the case,
> just uncommenting it now should get it working right?

Commented out means that the default value is used, which is on for both
of those.  That means that autovacuum should already be running.  Is
there some reason you think it isn't?

	Thanks,

		Stephen

--EiEtkL13vkX+L2A+
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: Digital signature
Content-Disposition: inline

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.10 (GNU/Linux)

iEYEARECAAYFAk2VOgsACgkQrzgMPqB3kignEgCdFE+Ij+EbX+zC/rUtugZrG1nA
sHoAoIZlmfjTlONs0fPA//Rz6g0HRoVn
=D+LS
-----END PGP SIGNATURE-----

--EiEtkL13vkX+L2A+--