Date: Mon, 12 Sep 2011 21:15:16 -0400
From: Stephen Frost <sfrost@snowman.net>
To: Robert Schnabel <schnabelr@missouri.edu>
Cc: Scott Marlowe <scott.marlowe@gmail.com>,
	pgsql-performance <pgsql-performance@postgresql.org>
Subject: Re: Allow sorts to use more available memory
Message-ID: <20110913011516.GU12765@tamriel.snowman.net>
References: <4E6E426D.7060405@missouri.edu>
	<CAOR=d=1WgWOPz+8t9FqqNbbabNKu6DOm-z0S1MJ0jGe+FsRGfw@mail.gmail.com>
	<4E6E830E.30701@missouri.edu>
MIME-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha1;
	protocol="application/pgp-signature"; boundary="O2qoDrRdTxptnP8M"
Content-Disposition: inline
In-Reply-To: <4E6E830E.30701@missouri.edu>
User-Agent: Mutt/1.5.20 (2009-06-14)


--O2qoDrRdTxptnP8M
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable

* Robert Schnabel (schnabelr@missouri.edu) wrote:
> And getting back to the to-do list entry and reading the related
> posts, it appears that even if you could set work_mem that high it
> would only use 2GB anyway.  I guess that was the second part of my
> question.  Is that true?

Errr, and to get back to the to-do (which I've been considering doing
something about...), it's to allow the *actual* memory usage for things
like sorts to use more than 2GB, but as others have pointed out, you can
do that by putting pgsql_tmp on a memory filesystem and letting the
sorts spill to the memory-based FS.
=09
	Thanks,

		Stephen

--O2qoDrRdTxptnP8M
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)

iEYEARECAAYFAk5urqQACgkQrzgMPqB3kijemACcDlLbseP8KGjOBcAHtMb9OnET
3NwAnizJkqPDYvDjg//puuWIQ8jvq28U
=N4zM
-----END PGP SIGNATURE-----

--O2qoDrRdTxptnP8M--