Re: Understand this error - Mailing list pgsql-general

From Tom Lane
Subject Re: Understand this error
Date
Msg-id 13161.1241193021@sss.pgh.pa.us
Whole thread Raw
In response to Re: Understand this error  (Craig Ringer <craig@postnewspapers.com.au>)
List pgsql-general
Craig Ringer <craig@postnewspapers.com.au> writes:
> Note that it's not very likely that PostgreSQL was the process that used
> up all your memory. It was just unlucky enough to be picked as the one
> to be killed, because the OOM killer is terrible at estimating which
> process is using the most memory when programs like PostgreSQL have
> allocated large blocks of shared memory.

It's worse than that: the OOM killer is broken by design, because it
intentionally picks on processes that have a lot of large children
--- without reference to the fact that a lot of the "largeness" might
be the same shared memory block.  So the postmaster process very often
looks like a good target to it, even though killing the postmaster will
in fact free a negligible amount of memory.

            regards, tom lane

pgsql-general by date:

Previous
From: Peter Geoghegan
Date:
Subject: Re: Connecting to a postgreSQL database with windows CE over wi-fi; failing gracefully
Next
From: PostGre Newbie
Date:
Subject: Online Backups PostGre