X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 9C2AFD9062 for ; Mon, 10 Oct 2005 18:45:43 -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 73001-02 for ; Mon, 10 Oct 2005 21:45:40 +0000 (GMT) Received: from wproxy.gmail.com (wproxy.gmail.com [64.233.184.197]) by svr1.postgresql.org (Postfix) with ESMTP id 885C1D9E34 for ; Mon, 10 Oct 2005 18:45:41 -0300 (ADT) Received: by wproxy.gmail.com with SMTP id 71so141786wra for ; Mon, 10 Oct 2005 14:45:44 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=EDgS4tv4bdHqDE1+iE9WA3bNWioYZQms8H/4q9gDQE5GVPUXqOWoFh6NO3u94hsedfKJa8KfV3zvk7iK5nMsUXWc/l/IxWGdd98TBJ6rYZ/wgq0RG0HzW33uAf3iK/s0SQSvZgDFfrKqMSF4iMvLHAy8UEocQfN4dfaNtZ2IIa0= Received: by 10.54.71.5 with SMTP id t5mr3358784wra; Mon, 10 Oct 2005 14:45:44 -0700 (PDT) Received: by 10.54.144.4 with HTTP; Mon, 10 Oct 2005 14:45:44 -0700 (PDT) Message-ID: Date: Mon, 10 Oct 2005 23:45:44 +0200 From: Claus Guttesen To: Jon Brisbin Subject: Re: Performance on SUSE w/ reiserfs Cc: pgsql-performance@postgresql.org In-Reply-To: <434ADD46.5060206@npcinternational.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline References: <434ADD46.5060206@npcinternational.com> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.024 required=5 tests=[AWL=-0.000, RCVD_BY_IP=0.024] X-Spam-Level: X-Archive-Number: 200510/173 X-Sequence-Number: 14941 > I have a SUSE 9 box that is running Postgres 8.0.1 compiled from source. > Over time, I see the memory usage of the box go way way up (it's got > 8GBs in it and by the end of the day, it'll be all used up) with what > looks like cached inodes relating to the extreme IO generated by > > I was wondering if there is something I'm doing wrong with my default > settings of postgres that is keeping all that stuff cached, or if I just > need to switch to XFS or if there is some setting in postgres that I can > tweak that will make this problem go away. It's gone beyond an annoyance > and is now into the realm of getting me in trouble if I can't keep this > DB server up and running. Even a minute or two of downtime in a restart > is often too much. > > Any help you can give in this would be extrememly helpful as I'm very > far from an expert on Linux filesystems and postgres tuning. You may want to submit your postgresql.conf. Upgrading to the latest stable version may also help, although my experience is related to FreeBSD and postgresql 7.4.8. regards Claus