On Mon, Oct 22, 2007 at 08:04:03AM -0700, Trevor Talbot wrote: > On 10/22/07, Dave Page <dpage@xxxxxxxxxxxxxx> wrote: > > Dave Page wrote: > > > So, we seem to be hitting two limits here - the desktop heap, and > > > something else which is cluster-specific. Investigation continues... > > > > In further info, I've been testing this with the 8.3b1 release build > > that we put out with pgInstaller, and a build with all optional > > dependencies (OpenSSL, Kerberos, gettext, ldap etc) disabled. I'm seeing > > pretty much the same results with each - roughtly 9.6KB of desktop heap > > used per connection. > > The question is where that's coming from. I wondered if it was > desktop heap originally, but there's no reason it should be using it, > and that seems to be precisely the difference between my system and > the others. Connections here are barely making a dent; at 490 there's > an entire 45KB committed in the service desktop. Yes, that would be very interesting to know. Because obviouslyi it's something. I read somewhere that Vista makes the size of the desktop heap dynamic, but you were on 2003, right? Are you running the server as a service or from the commandprompt? > > Magnus and I did observe that we're using 1 user object and 4 GDI > > objects per connection. If anyone happens to know how we might identify > > those, please shout as so far we've drawn a blank :-( > > Those appear to belong to the console window. Makes sense - a Windows, a system menu, etc. There's probably a "hidden console window" when running as a service... > I've yet to do anything that generates real load (lightweight system), > but a simple "select version()" doesn't make any difference here > either, and raising shared buffers just makes postmaster run out of VM > space faster. (I don't think I mentioned that error before, but it > shows up as "FATAL: could not create sigchld waiter thread: error > code 8".) Yeah, that makes sense. We need to fix that, but I think that's too big of a change to push during beta, given how few reports we've had of people running into it. //Magnus ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
