pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Kevin Schroeder <kschroeder@mirageworks.com>
To: pgsql-performance@postgresql.org
Subject: Re: Swapping on Solaris
Date: Wed, 19 Jan 2005 08:52:28 -0600
Message-ID: <010c01c4fe36$7ecba1a0$0200a8c0@WORKSTATION> (raw)
References: <042a01c4fdaf$fbb3b860$0200a8c0@WORKSTATION>
	<41EE0F05.9080901@coretech.co.nz>
	<25392.193.190.212.113.1106128630.squirrel@193.190.212.113>

po and pi are relatively low, but do pick up when there's an increase in 
activity.  I am seeing a lot of "minor faults", though.  vmstat -S 5 reports

 [9:38am]# vmstat -S 5
 procs     memory            page            disk          faults      cpu
 r b w   swap  free  si  so pi po fr de sr s0 s1 s3 --   in   sy   cs us sy 
id
 0 0 0 3235616 1414536 0  0 303 11 10 0  0  6 24  0  0   13  192  461 17 11 
72
 1 0 0 3004376 1274912 0  0  0  0  0  0  0  3 16  0  0  494 1147  441 52 25 
23

494 in faults
1147 sy faults

Generally faults are a bad thing.  Is that the case here?

Kevin

----- Original Message ----- 
From: "Matt Casters" <Matt.Casters@advalvas.be>
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 <matt.casters@ibridge.be>
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 majordomo@postgresql.org)






view thread (22+ messages)  latest in thread

Message-ID: <010c01c4fe36$7ecba1a0$0200a8c0@WORKSTATION>
Permalink:  ../010c01c4fe36$7ecba1a0$0200a8c0@WORKSTATION/
Also on:    postgresql.org/message-id/010c01c4fe36$7ecba1a0$0200a8c0@WORKSTATION

 · 

reply

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 using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: kschroeder@mirageworks.com
  Subject: Re: Swapping on Solaris
  In-Reply-To: <010c01c4fe36$7ecba1a0$0200a8c0@WORKSTATION>

* 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