pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Tom Arthurs <tarthurs@jobflash.com>
To: Jim C. Nasby <jnasby@pervasive.com>
Cc: Dan Austin <DAustin@au.westfield.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: Pgstat.tmp file activity
Date: Tue, 27 Dec 2005 13:15:39 -0800
Message-ID: <43B1AEFB.6030802@jobflash.com> (raw)
In-Reply-To: <20051227210844.GP72143@pervasive.com>
References: <ED242F3A9037824A952B71B480A5D7ED6DFAD1@ausyd-exmb01.au.ad.westfield.com>
	<20051227210844.GP72143@pervasive.com>

 From http://docs.sun.com/source/817-1836-10/perfplat.html

High File System Page-in Rate

If you are seeing high file system page-in rates on Solaris 8 or 9, you 
may benefit from increasing the value of segmap_percent. This parameter 
is set by adding the following line to the /etc/system file:

set segmap_percent=25

segmap_percent adjusts the percentage of memory that the kernel will map 
into its address space for the file system cache. The default value is 
12; that is, the kernel will reserve enough space to map at most 12% of 
memory for the file system cache. On a heavily loaded machine with 4 GB 
of physical memory, improvements have been seen with values as high as 
60. You should experiment with this value, starting with values around 
25. On systems with large amounts of physical memory, you should raise 
this value in small increments, as it can significantly increase kernel 
memory requirements.
====================================

I think this can also be set with the kernel debugger.

I keep it at 50% on my E3500 and E4500 systems (8 and 12 GB memory).

Jim C. Nasby wrote:

>On Fri, Dec 23, 2005 at 04:50:32PM +1100, Dan Austin wrote:
>  
>
>>>[...]
>>>Right, the file is fully written under a temp name, and then 
>>>rename()'d
>>>      
>>>
>>This makes sense and is almost certainly not the cause of the problem.
>>Although there is a lot more data being written to that file than I
>>would have thought.
>>
>>One of Sun's kernel engineers has come up with a solution that seems to
>>have fixed the problem. Instead of increasing work_mem (which we still
>>might do) we've mounted a swapfs partition over the pg temp directory:
>>
>>  # mount | grep pgsql_tmp
>>  /export/data/pgsql/data/base/64920741/pgsql_tmp on swap [...]
>>
>>This has actually reduced the disk activity considerably. So far, the
>>blocking problem seems to have gone.
>>
>>Now to find some Postgres DBAs in Sydney to do some review / tuning of
>>our memory settings. :-)
>>    
>>
>
>Note also that Solaris by default limits the amount of memory used for
>disk caching, which is Not Good for PostgreSQL. IIRC this can be changed
>with a sysctl, but I don't recall the details off-hand.
>  
>




view thread (10+ messages)  latest in thread

Message-ID: <43B1AEFB.6030802@jobflash.com>
Permalink:  ../43B1AEFB.6030802@jobflash.com/
Also on:    postgresql.org/message-id/43B1AEFB.6030802@jobflash.com

 · 

reply

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 from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: tarthurs@jobflash.com, jnasby@pervasive.com, DAustin@au.westfield.com
  Subject: Re: Pgstat.tmp file activity
  In-Reply-To: <43B1AEFB.6030802@jobflash.com>
  References: <ED242F3A9037824A952B71B480A5D7ED6DFAD1@ausyd-exmb01.au.ad.westfield.com> <20051227210844.GP72143@pervasive.com> <43B1AEFB.6030802@jobflash.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