On Thu, 27 Jun 2002, Tom Lane wrote:
> So you haven't really solved the problem --- somewhere there is a query
> being issued that ramps the backend up to a lot of memory. All you've
> done is ensured that the backend won't hang around very long. The
> persistent connection isn't really at fault, except in that it causes
> backends to keep being used after their memory usage has become bloated.
Yeah, but if the queries after that are not using all of the mapped
memory, that should be swapped out fairly quickly because the
machine is short on memory.
Same for memory leaks; if you're losing a lot of memory, you'd
think there would be a fair number of pages you never touch that
could then be swapped out.
The bloated processes, at least from the top fragment I saw, appear
to have a working set of 200-250 MB; basically the entire data
space is resident. So what's touching all of those pages often
enough that they don't get swapped?
Curt Sampson <cjs(at)cynic(dot)net> +81 90 7737 2974 http://www.netbsd.org
Don't you know, in this new Dark Age, we're all light. --XTC
In response to
pgsql-general by date
|Next:||From: Nigel J. Andrews||Date: 2002-06-28 10:12:30|
|Subject: Re: 7.2.1 optimises very badly against 7.2|
|Previous:||From: Sam Liddicott||Date: 2002-06-28 09:33:59|
|Subject: 7.2.1 optimises very badly against 7.2|