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
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 |
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 |