Received: from maia.hub.org (maia-3.hub.org [200.46.204.243])
	by mail.postgresql.org (Postfix) with ESMTP id 89E501337B5C
	for <pgsql-performance-postgresql.org@mail.postgresql.org>;
	Thu,  7 Oct 2010 16:02:17 -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 24980-03
	for <pgsql-performance-postgresql.org@mail.postgresql.org>;
	Thu,  7 Oct 2010 19:02:09 +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 232771337B4A
	for <pgsql-performance@postgresql.org>;
	Thu,  7 Oct 2010 16:02:09 -0300 (ADT)
Received: by tamriel.snowman.net (Postfix, from userid 1000)
	id 19DBD22942; Thu,  7 Oct 2010 15:02:09 -0400 (EDT)
Date: Thu, 7 Oct 2010 15:02:08 -0400
From: Stephen Frost <sfrost@snowman.net>
To: Aaron Turner <synfinatic@gmail.com>
Cc: pgsql-performance <pgsql-performance@postgresql.org>
Subject: Re: large dataset with write vs read clients
Message-ID: <20101007190208.GB26232@tamriel.snowman.net>
References: <AANLkTimNJc=0ffgRO_gO6Vsq06=aqBYXZouhbv0kBe-i@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha1;
	protocol="application/pgp-signature"; boundary="5PVY+vURQto0KJVL"
Content-Disposition: inline
In-Reply-To: <AANLkTimNJc=0ffgRO_gO6Vsq06=aqBYXZouhbv0kBe-i@mail.gmail.com>
X-Editor: Vim http://www.vim.org/
X-Info: http://www.snowman.net
X-Operating-System: Linux/2.6.26-1-amd64 (x86_64)
X-Uptime: 15:00:34 up 406 days,  6:25, 14 users,  load average: 0.30, 0.17,
	0.11
User-Agent: Mutt/1.5.18 (2008-05-17)
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: 201010/65
X-Sequence-Number: 40484


--5PVY+vURQto0KJVL
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline

* Aaron Turner (synfinatic@gmail.com) wrote:
> Basically, each connection is taking about 100MB resident

Errr..  Given that your shared buffers are around 100M, I think you're
confusing what you see in top with reality.  The shared buffers are
visible in every process, but it's all the same actual memory, not 100M
per process.

	Thanks,

		Stephen

--5PVY+vURQto0KJVL
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: Digital signature
Content-Disposition: inline

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

iEYEARECAAYFAkyuGTAACgkQrzgMPqB3kiiGPQCfeFhMvfRo9V6m2ELd53+ONblu
dPMAoIORqDGDixI3W61Gw/YzkXvpWbdr
=g6ux
-----END PGP SIGNATURE-----

--5PVY+vURQto0KJVL--