Re: 8.4devel out of memory - Mailing list pgsql-hackers

From Tom Lane
Subject Re: 8.4devel out of memory
Date
Msg-id 26884.1220634137@sss.pgh.pa.us
Whole thread Raw
In response to Re: 8.4devel out of memory  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Responses Re: 8.4devel out of memory  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Re: 8.4devel out of memory  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
List pgsql-hackers
"Kevin Grittner" <Kevin.Grittner@wicourts.gov> writes:
>     PortalHeapMemory: 1620992 total in 200 blocks; 5856 free (8 chunks); 1615136 used
>       ExecutorState: 2787288448 total in 364 blocks; 328 free (5 chunks); 2787288120 used

Ouch.  We have created a memory leak someplace, but it's hard to tell
where from this info.  Can you boil this down into a self-contained test
case?  I doubt it depends at all on the specific data, so the table &
view definitions plus some dummy data would probably be enough to
reproduce it.

Is this a 32-bit or 64-bit build?  Also, does the leak still occur if
you just run the query as-is rather than EXPLAIN ANALYZE it?
        regards, tom lane


pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: plpgsql is not translate-aware
Next
From: Andrew Chernow
Date:
Subject: CVS head has broken make