Re: 8.2.3: Server crashes on Windows using Eclipse/Junit

From: Dave Page <dpage(at)postgresql(dot)org>
To: Rainer Bauer <usenet(at)munnin(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: 8.2.3: Server crashes on Windows using Eclipse/Junit
Date: 2007-10-23 15:14:14
Message-ID: 471E0FC6.5080909@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

Rainer Bauer wrote:
>> ...yep, under XP I'm using about 3.1KB of the service heap per
>> connection, which tears through it quite a bit faster. Now to figure
>> out exactly where it's coming from...
>
> I can confirm this here (WinXP SP2).

It's coming from direct dependencies on user32.dll (from which we use
wsprintf()) and shell32.dll (from which we use SHGetSpecialFolderPath())
and is allocated when ResumeThread() is called to kickstart the new
backend, but before the backend actually does anything (proven with a
while(1) loop in main() for the -forkbackend case with a breakpoint on
ResumeThread() in the postmaster).

I've submitted a patch against 8.3 that removes these dependencies
altogether. Unfortuntely, it seems we still have indirect dependencies
on user32.dll which I don't believe we can do anything about. In
testing, the patch reduces the per-connection desktop heap usage from
arount 9.7KB to 3.2KB which is back in line with 8.2.

Regards, Dave

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alvaro Herrera 2007-10-23 15:32:16 Re: autovacuum and locks
Previous Message Dietmar Maurer 2007-10-23 15:03:51 Re: autovacuum and locks

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2007-10-23 15:16:24 Re: Latin vs non-Latin words in text search parsing
Previous Message Tom Lane 2007-10-23 15:10:39 Re: ts_rewrite aggregate API seems mighty ugly