X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 909393A420D for ; Wed, 19 Jan 2005 14:57:25 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 96518-03 for ; Wed, 19 Jan 2005 14:57:14 +0000 (GMT) Received: from mail.blogtap.com (66.241.8.26.maxuptime.com [66.241.8.26]) by svr1.postgresql.org (Postfix) with ESMTP id 8B3163A42A7 for ; Wed, 19 Jan 2005 14:57:14 +0000 (GMT) Received: from WORKSTATION (c-24-1-91-108.client.comcast.net [24.1.91.108]) by mail.blogtap.com (Postfix) with ESMTP id 6797D68015 for ; Wed, 19 Jan 2005 08:55:15 -0600 (CST) Message-ID: <011f01c4fe37$2ea10f20$0200a8c0@WORKSTATION> From: "Kevin Schroeder" To: References: <042a01c4fdaf$fbb3b860$0200a8c0@WORKSTATION> <41EE0F05.9080901@coretech.co.nz> <25392.193.190.212.113.1106128630.squirrel@193.190.212.113> Subject: Re: Swapping on Solaris Date: Wed, 19 Jan 2005 08:57:23 -0600 MIME-Version: 1.0 Content-Type: text/plain; format=flowed; charset="iso-8859-1"; reply-type=original Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2900.2180 X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 X-Virus-Scanned: by amavisd-new at hub.org X-Archive-Number: 200501/235 X-Sequence-Number: 9925 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" 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 > :-) > 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 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)