Re: 8.4devel out of memory

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: 8.4devel out of memory
Date: 2008-09-05 19:24:34
Message-ID: 48C14122.EE98.0025.0@wicourts.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

>>> Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> Also, does the leak still occur if
> you just run the query as-is rather than EXPLAIN ANALYZE it?

The machine became unresponsive similar to the early symptoms of the
apparent memory leak cited in this post:

http://archives.postgresql.org/pgsql-bugs/2008-07/msg00105.php

It was impossible to kill the offending process, since the connections
were unresponsive; we didn't wait for the OOM killer, but rebooted the
machine.

-Kevin

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Joshua Drake 2008-09-05 19:27:08 Re: reducing statistics write overhead
Previous Message Tom Lane 2008-09-05 19:23:18 Re: reducing statistics write overhead