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 9C2C3D1B178 for ; Thu, 15 Jul 2004 13:19:37 -0300 (ADT) 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 39531-08 for ; Thu, 15 Jul 2004 16:19:29 +0000 (GMT) Received: from mpls-qmqp-04.inet.qwest.net (mpls-qmqp-04.inet.qwest.net [63.231.195.115]) by svr1.postgresql.org (Postfix) with SMTP id 9D01BD1B170 for ; Thu, 15 Jul 2004 13:19:27 -0300 (ADT) Received: (qmail 63781 invoked by uid 0); 15 Jul 2004 16:19:27 -0000 Received: from mpls-pop-08.inet.qwest.net (63.231.195.8) by mpls-qmqp-04.inet.qwest.net with QMQP; 15 Jul 2004 16:19:27 -0000 Received: from 63-227-127-37.dnvr.qwest.net (HELO ?10.0.0.2?) (63.227.127.37) by mpls-pop-08.inet.qwest.net with SMTP; 15 Jul 2004 16:19:26 -0000 Date: Thu, 15 Jul 2004 10:20:34 -0600 Message-Id: <1089908434.21324.8.camel@localhost.localdomain> From: "Scott Marlowe" To: jim.ewert@excite.com Cc: matthew@zeut.net, pgsql-performance@postgresql.org Subject: Re: Swapping in 7.4.3 In-Reply-To: <20040715134933.782C43955@xprdmailfe9.nwk.excite.com> References: <20040715134933.782C43955@xprdmailfe9.nwk.excite.com> Content-Type: text/plain Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.6 (1.4.6-2) Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.1 tagged_above=0.0 required=5.0 tests=HTML_MESSAGE, RCVD_IN_SORBS X-Spam-Level: X-Archive-Number: 200407/99 X-Sequence-Number: 7490 This is normal. My personal workstation has been up for 16 days, and it shows 65 megs used for swap. The linux kernel looks for things that haven't been accessed in quite a while and tosses them into swap to free up the memory for other uses. This isn't PostgreSQL's fault, or anything elses. It's how a typical Unix kernel works. I.e. you're seeing a problem that simply isn't there. On Thu, 2004-07-15 at 07:49, Jim Ewert wrote: > With pg_autovaccum it's now at 95M swap; averaging 5MB / day increase with same load. Cache slightly increases or decreases according to top. > > --- On Tue 07/13, Matthew T. O'Connor < matthew@zeut.net > wrote: > From: Matthew T. O'Connor [mailto: matthew@zeut.net] > To: jim.ewert@excite.com > Cc: pgsql-performance@postgresql.org > Date: Tue, 13 Jul 2004 16:26:09 -0400 > Subject: Re: [PERFORM] Swapping in 7.4.3 > > Jim Ewert wrote:
> When I went to 7.4.3 (Slackware 9.1) w/ JDBC, the improvements are that it doesn't initially take much memory (have 512M) and didn't swap. I ran a full vaccum and a cluster before installation, however speed degaded to 1 *second* / update of one row in 150 rows of data, within a day! pg_autovacuum now gives excellent performance however it is taking 66M of swap; only 270k cached.
>

Are you saying that your system stays fast now that you are using
pg_autovacuum, but pg_autovacuum is using 66M of memory? Please
clarify, I'm not sure what question you want an answered.

Matthew

> > _______________________________________________ > Join Excite! - http://www.excite.com > The most personalized portal on the Web! > > ---------------------------(end of broadcast)--------------------------- > TIP 9: the planner will ignore your desire to choose an index scan if your > joining column's datatypes do not match >