From: Jim C. Nasby <jnasby@pervasive.com>
To: Tom Arthurs <tarthurs@jobflash.com>
Cc: Dan Austin <DAustin@au.westfield.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: Pgstat.tmp file activity
Date: Tue, 27 Dec 2005 15:39:37 -0600
Message-ID: <20051227213937.GR72143@pervasive.com> (raw)
In-Reply-To: <43B1AEFB.6030802@jobflash.com>
References: <ED242F3A9037824A952B71B480A5D7ED6DFAD1@ausyd-exmb01.au.ad.westfield.com>
<20051227210844.GP72143@pervasive.com>
<43B1AEFB.6030802@jobflash.com>
There's also a non-percent-based control as well. My understanding is
that segmap_percent doesn't work on some versions or architectures,
notably OpenSolaris.
On Tue, Dec 27, 2005 at 01:15:39PM -0800, Tom Arthurs wrote:
> 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.
> >
> >
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faq
>
--
Jim C. Nasby, Sr. Engineering Consultant jnasby@pervasive.com
Pervasive Software http://pervasive.com work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461
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: jnasby@pervasive.com, tarthurs@jobflash.com, DAustin@au.westfield.com
Subject: Re: Pgstat.tmp file activity
In-Reply-To: <20051227213937.GR72143@pervasive.com>
References: <ED242F3A9037824A952B71B480A5D7ED6DFAD1@ausyd-exmb01.au.ad.westfield.com> <20051227210844.GP72143@pervasive.com> <43B1AEFB.6030802@jobflash.com> <20051227213937.GR72143@pervasive.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