From: Mischa Sandberg <mischa@ca.sophos.com>
To: pgsql-performance@postgresql.org
Subject: Re: Solaris shared_buffers anomaly?
Date: Tue, 13 Jun 2006 17:01:34 -0700
Message-ID: <448F51DE.2070604@ca.sophos.com> (raw)
In-Reply-To: <20060613231730.GS34196@pervasive.com>
References: <1150151282.14661.42.camel@tigger>
<20060613000441.GI8588@kenobi.snowman.net>
<20060613200810.GZ34196@pervasive.com>
<448F3A6E.6080908@ca.sophos.com>
<20060613224759.GM34196@pervasive.com>
<448F4842.4010305@ca.sophos.com>
<20060613231730.GS34196@pervasive.com>
Jim C. Nasby wrote:
> On Tue, Jun 13, 2006 at 04:20:34PM -0700, Mischa Sandberg wrote:
>> Jim C. Nasby wrote:
>>> What's sort_mem set to? I suspect you simply ran the machine out of
>>> memory.
>> 8192 (8MB). No issue when shared_buffers was 2000; same apps always.
>
> So if all 50 backends were running a sort, you'd use 400MB. The box has
> 4G, right?
Umm ... yes. "if". 35-40 of them are doing pure INSERTS.
Not following your train.
>> Yep, tested /etc/system segmap_percent at 20,40,60.
>> No significant difference between 20 and 60.
> That's pretty disturbing... how large is your database?
~10GB. Good locality. Where heading?
--
Engineers think that equations approximate reality.
Physicists think that reality approximates the equations.
Mathematicians never make the connection.
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: mischa@ca.sophos.com
Subject: Re: Solaris shared_buffers anomaly?
In-Reply-To: <448F51DE.2070604@ca.sophos.com>
* 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