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.
>
>
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