On Mon, Oct 22, 2007 at 08:04:03AM -0700, Trevor Talbot wrote:
> On 10/22/07, Dave Page <dpage@postgresql.org> 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