Re: Postgres using more memory than it should - Mailing list pgsql-performance

From Scott Marlowe
Subject Re: Postgres using more memory than it should
Date
Msg-id dcc563d10812031114v4dfe5f7chd6c35fa939cf8205@mail.gmail.com
Whole thread Raw
In response to Re: Postgres using more memory than it should  (Matthew Wakeling <matthew@flymine.org>)
List pgsql-performance
On Wed, Dec 3, 2008 at 9:59 AM, Matthew Wakeling <matthew@flymine.org> wrote:
> On Wed, 3 Dec 2008, Scott Marlowe wrote:
>> Also, you should REALLY update to 8.3.5 as there are some nasty bugs
>> fixed from 8.3.0 you don't want to run into.  Who knows, you might be
>> being bitten by one right now.  Unlike other bits of software floating
>> around, pgsql updates are bug fix / security fix only, with no major
>> code changes allowed, since those go into the next release which is
>> usually ~1 year later anyway.
>
> It's possible, although I didn't see any relevant memory leaks in the
> release notes. This is one of the only machines we have that has not been
> upgraded, and it is on our schedule. Because it is running a slightly old
> version of RedHat Fedora, upgrading involves more horribleness than our
> sysadmin is willing to do on the fly with the server up.

That makes absolutely no sense.  If it's an in house built rpm, you
just create a new one with the same .spec file, if it was built from
source it's a simple ./configure --youroptionshere ;make;make install.
  You need a new sysadmin.

pgsql-performance by date:

Previous
From: hubert depesz lubaczewski
Date:
Subject: Re: Postgres using more memory than it should
Next
From: "Kynn Jones"
Date:
Subject: How to profile an "SQL script"?