On Wed, 26 Jun 2002, Alvar Freude wrote:
> > sort_mem = 8192 (16384 or 32768 didn't help either)
>
> Each sort can take up to 8 MB RAM; if you have some queries which needs
> e.g. 3 big sorts and have 30 from this in parallel, this takes ~720 MB RAM.
Not quite. As I mentioned earlier, postgres 7.2 actually allocates
between 2.5 and three times that amount of memory. So in your
example, you'd have 90 * 3 * 8 * 2.5 or more like 5 GB of memory. :-)
cjs
--
Curt Sampson <cjs@cynic.net> +81 90 7737 2974 http://www.netbsd.org
Don't you know, in this new Dark Age, we're all light. --XTC
