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

From Tom Lane
Subject Re: 8.4devel out of memory
Date
Msg-id 27521.1220635534@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>)
List pgsql-hackers
"Kevin Grittner" <Kevin.Grittner@wicourts.gov> writes:
> The tables and views aren't that hard; finding a way to generate
> enough fake data may be a challenge.  (I assume that since it took
> over a half hour to run out of memory, the volume of data needs to be
> sufficient to get there.)

We don't really need 2GB of leakage to find the problem ... a query
that generates a couple hundred meg of bloat would be plenty.

Since we don't know how much space the query would have needed to run to
completion, it's likely that something involving much less than a tenth
as much data would still be enough to make the leak obvious.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: CVS head has broken make
Next
From: "Asko Oja"
Date:
Subject: Re: Withdraw PL/Proxy from commitfest