From: Stephen Frost <sfrost@snowman.net>
To: Robert Schnabel <schnabelr@missouri.edu>
Cc: Scott Marlowe <scott.marlowe@gmail.com>
Cc: pgsql-performance <pgsql-performance@postgresql.org>
Subject: Re: Allow sorts to use more available memory
Date: Mon, 12 Sep 2011 21:15:16 -0400
Message-ID: <20110913011516.GU12765@tamriel.snowman.net> (raw)
In-Reply-To: <4E6E830E.30701@missouri.edu>
References: <4E6E426D.7060405@missouri.edu>
<CAOR=d=1WgWOPz+8t9FqqNbbabNKu6DOm-z0S1MJ0jGe+FsRGfw@mail.gmail.com>
<4E6E830E.30701@missouri.edu>
* 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.
Thanks,
Stephen
Attachments:
signature.asc (application/pgp-signature, 197B) download
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: sfrost@snowman.net, schnabelr@missouri.edu, scott.marlowe@gmail.com
Subject: Re: Allow sorts to use more available memory
In-Reply-To: <20110913011516.GU12765@tamriel.snowman.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox