Andrew Sullivan wrote:
> On Wed, Jan 19, 2005 at 10:42:26AM -0500, Alan Stange wrote:
> >
> > I'm fairly sure that the pi and po numbers include file IO in Solaris,
> > because of the unified VM and file systems.
>
> That's correct.
I have seen cases on BSDs where 'pi' includes page-faulting in
On Wed, Jan 19, 2005 at 10:42:26AM -0500, Alan Stange wrote:
>
> I'm fairly sure that the pi and po numbers include file IO in Solaris,
> because of the unified VM and file systems.
That's correct.
A
--
Andrew Sullivan | [EMAIL PROTECTED]
When my information changes, I alter my conclusions.
On Wed, 2005-01-19 at 09:40 -0600, Kevin Schroeder wrote:
> I may be asking the question the wrong way, but when I start up PostgreSQL
> swap is what gets used the most of. I've got 1282MB free RAM right now and
> and 515MB swap in use. Granted, swap file usage probably wouldn't be zero,
> but
al Message -
From: "Matt Clark" <[EMAIL PROTECTED]>
To: "Kevin Schroeder" <[EMAIL PROTECTED]>
Cc:
Sent: Wednesday, January 19, 2005 1:01 PM
Subject: Re: [PERFORM] Swapping on Solaris
This page may be of use:
http://www.serverworldmagazine.com/monthly/2003/02/solaris
available
Kevin
- Original Message - From: "Alan Stange" <[EMAIL PROTECTED]>
To: "Kevin Schroeder" <[EMAIL PROTECTED]>
Cc:
Sent: Wednesday, January 19, 2005 11:04 AM
Subject: Re: [PERFORM] Swapping on Solaris
Kevin Schroeder wrote:
I may be asking the question t
On Jan 19, 2005, at 10:40 AM, Kevin Schroeder wrote:
I may be asking the question the wrong way, but when I start up
PostgreSQL swap is what gets used the most of. I've got 1282MB free
RAM right now and and 515MB swap in use. Granted, swap file usage
probably wouldn't be zero, but I would gues
Kevin Schroeder wrote:
I may be asking the question the wrong way, but when I start up
PostgreSQL swap is what gets used the most of. I've got 1282MB free
RAM right now and and 515MB swap in use. Granted, swap file usage
probably wouldn't be zero, but I would guess that it should be a lot
low
used, 2988840k
available
Kevin
- Original Message -
From: "Alan Stange" <[EMAIL PROTECTED]>
To: "Kevin Schroeder" <[EMAIL PROTECTED]>
Cc:
Sent: Wednesday, January 19, 2005 11:04 AM
Subject: Re: [PERFORM] Swapping on Solaris
Kevin Schroeder wrote:
I may
On Jan 19, 2005, at 10:42 AM, Alan Stange wrote:
Kevin Schroeder wrote:
I take that back. There actually is some paging going on. I ran sar
-g 5 10 and when a request was made (totally about 10 DB queries) my
pgout/s jumped to 5.8 and my ppgout/s jumped to 121.8. pgfree/s also
jumped to 121.8
--
From: "Alan Stange" <[EMAIL PROTECTED]>
To: "Kevin Schroeder" <[EMAIL PROTECTED]>
Cc:
Sent: Wednesday, January 19, 2005 9:30 AM
Subject: Re: [PERFORM] Swapping on Solaris
Kevin Schroeder wrote:
I suspect that the memory is being used to cache files as well
Kevin Schroeder wrote:
I take that back. There actually is some paging going on. I ran sar
-g 5 10 and when a request was made (totally about 10 DB queries) my
pgout/s jumped to 5.8 and my ppgout/s jumped to 121.8. pgfree/s also
jumped to 121.80.
I'm fairly sure that the pi and po numbers inc
in Schroeder" <[EMAIL PROTECTED]>
Cc:
Sent: Wednesday, January 19, 2005 9:42 AM
Subject: Re: [PERFORM] Swapping on Solaris
Kevin Schroeder wrote:
I take that back. There actually is some paging going on. I ran sar -g
5 10 and when a request was made (totally about 10 DB queries)
Alan Stange wrote:
Note that files in /tmp are usually in a tmpfs file system. These
files may be the usage of swap that you're seeing (as they will be paged
out on an active system with some memory pressure)
You can do a couple things with /tmp. Create a separate file system
for it so it will
Kevin Schroeder wrote:
I suspect that the memory is being used to cache files as well since
the email boxes are using unix mailboxes, for the time being. With
people checking their email sometimes once per minute I can see why
Solaris would want to cache those files. Perhaps my question would
r PostgreSQL to be swapped unless that free
memory is Solaris caching files in RAM.
Kevin
- Original Message -
From: "Greg Spiegelberg" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: "Kevin Schroeder" <[EMAIL PROTECTED]>;
Sent: Wednesday, Januar
Stange" <[EMAIL PROTECTED]>
Cc: "Kevin Schroeder" <[EMAIL PROTECTED]>;
Sent: Wednesday, January 19, 2005 7:51 AM
Subject: Re: [PERFORM] Swapping on Solaris
Mark Kirkwood wrote:
Kevin Schroeder wrote:
Ignoring the fact that the sort and vacuum numbers are really h
t; <[EMAIL PROTECTED]>
To:
Sent: Wednesday, January 19, 2005 3:57 AM
Subject: Re: [PERFORM] Swapping on Solaris
Kevin Schroeder wrote:
It looks to me like you are using no (device or file) swap at all, and
have 1.3G of real memory free, so could in fact give Postgres more of it
:-)
Indee
- Original Message -
From: "Matt Casters" <[EMAIL PROTECTED]>
To:
Sent: Wednesday, January 19, 2005 3:57 AM
Subject: Re: [PERFORM] Swapping on Solaris
Kevin Schroeder wrote:
It looks to me like you are using no (device or file) swap at all, and
have 1.3G of real memory free,
Mark Kirkwood wrote:
Kevin Schroeder wrote:
Ignoring the fact that the sort and vacuum numbers are really high,
this is what Solaris shows me when running top:
Memory: 2048M real, 1376M free, 491M swap in use, 2955M swap free
Maybe check the swap usage with 'swap -l' which reports reliably if an
> Kevin Schroeder wrote:
> It looks to me like you are using no (device or file) swap at all, and
> have 1.3G of real memory free, so could in fact give Postgres more of it :-)
>
Indeed.
If you DO run into trouble after giving Postgres more RAM, use the vmstat
command.
You can use this command l
Kevin Schroeder wrote:
Ignoring the fact that the sort and vacuum numbers are really high, this
is what Solaris shows me when running top:
Memory: 2048M real, 1376M free, 491M swap in use, 2955M swap free
Maybe check the swap usage with 'swap -l' which reports reliably if any
(device or file) sw
Hello,
I'm running PostgreSQL on a Solaris 8 system with 2GB of RAM and I'm
having some difficulty getting PostgreSQL to use the available RAM. My RAM
settings in postgresql.conf are
shared_buffers = 8192 # min 16, at least max_connections*2, 8KB each
sort_mem = 131072 # min
22 matches
Mail list logo
