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 the
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.
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 like
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
Message -
From: Matt Casters [EMAIL PROTECTED]
To: pgsql-performance@postgresql.org
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
PROTECTED]
To: pgsql-performance@postgresql.org
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
: Kevin Schroeder [EMAIL PROTECTED];
pgsql-performance@postgresql.org
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 high, this
is what Solaris shows me
: [PERFORM] Swapping on Solaris
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
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
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
: pgsql-performance@postgresql.org
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) my pgout/s
jumped
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
Stange [EMAIL PROTECTED]
To: Kevin Schroeder [EMAIL PROTECTED]
Cc: pgsql-performance@postgresql.org
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 since the
email boxes
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
available
Kevin
- Original Message -
From: Alan Stange [EMAIL PROTECTED]
To: Kevin Schroeder [EMAIL PROTECTED]
Cc: pgsql-performance@postgresql.org
Sent: Wednesday, January 19, 2005 11:04 AM
Subject: Re: [PERFORM] Swapping on Solaris
Kevin Schroeder wrote:
I may be asking the question
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
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
- From: Alan Stange [EMAIL PROTECTED]
To: Kevin Schroeder [EMAIL PROTECTED]
Cc: pgsql-performance@postgresql.org
Sent: Wednesday, January 19, 2005 11:04 AM
Subject: Re: [PERFORM] Swapping on Solaris
Kevin Schroeder wrote:
I may be asking the question the wrong way, but when I start up
PostgreSQL swap
-
From: Matt Clark [EMAIL PROTECTED]
To: Kevin Schroeder [EMAIL PROTECTED]
Cc: pgsql-performance@postgresql.org
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.shtml
From personal
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 I
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
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)
22 matches
Mail list logo