Hit by the out of memory killer last night

From: Bryan Murphy <bmurphy1976(at)gmail(dot)com>
To: PGSQL Mailing List <pgsql-general(at)postgresql(dot)org>
Subject: Hit by the out of memory killer last night
Date: 2011-01-31 15:55:43
Message-ID: AANLkTi=vKjPvpxSjKNf6HRncra7DSf2ssuS_MDhfjM9M@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Last night we were hit by the out of memory killer. Looking at the
following graph, you can clearly see unusual memory growth. This is a
database server running Postgres 9.0.0.

http://mediafly-public.s3.amazonaws.com/dbcluster02-master-month.png

We have another server, running Postgres 9.0.1 which showing a similar
behavior pattern:

http://mediafly-public.s3.amazonaws.com/dbcluster03-master-month.png

Compare these to another server which is running 8.3.7 and does not exhibit
this behavior:

http://mediafly-public.s3.amazonaws.com/dbcluster01-master-month.png

We're going to accelerate our upgrade to 9.0.2 for these servers, however,
I'm concerned that we have not identified the source of the memory leak and
this upgrade won't necessarily fix the problem.

Any advice? What should I be looking for?

Thanks,
Bryan

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Steve White 2011-01-31 16:09:08 include source file from another language into function body?
Previous Message dennis jenkins 2011-01-31 15:50:33 Re: Postgresql-8.4.6, 64bit, Solaris 10u9, dtrace