From: Claus Guttesen <kometen@gmail.com>
To: Jon Brisbin <jon.brisbin@npcinternational.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Performance on SUSE w/ reiserfs
Date: Mon, 10 Oct 2005 23:45:44 +0200
Message-ID: <b41c75520510101445jd8a9f06k@mail.gmail.com> (raw)
In-Reply-To: <434ADD46.5060206@npcinternational.com>
References: <434ADD46.5060206@npcinternational.com>
> 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
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: kometen@gmail.com, jon.brisbin@npcinternational.com
Subject: Re: Performance on SUSE w/ reiserfs
In-Reply-To: <b41c75520510101445jd8a9f06k@mail.gmail.com>
* 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