Message-ID: <448F51DE.2070604@ca.sophos.com>
Date: Tue, 13 Jun 2006 17:01:34 -0700
From: Mischa Sandberg <mischa@ca.sophos.com>
Reply-To: mischa@ca.sophos.com
User-Agent: Thunderbird 1.5.0.4 (X11/20060516)
MIME-Version: 1.0
To: pgsql-performance@postgresql.org
Subject: Re: Solaris shared_buffers anomaly?
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>
In-Reply-To: <20060613231730.GS34196@pervasive.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

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.