Re: [PERFORM] Swapping on Solaris

[Kevin Schroeder]

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.

Kevin
----- Original 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 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 "vmstat 10". (ignore the first line)
Keep an eye on the "pi" and "po" parameters. (kilobytes paged in and out)

HTH,
Matt
------
Matt Casters <[EMAIL PROTECTED]>
i-Bridge bvba, http://www.kettle.be
Fonteinstraat 70, 9400 Okegem, Belgium
Phone +32 (0) 486/97.29.37
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
   (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
              http://archives.postgresql.org