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

From: Magnus Hagander <magnus(at)hagander(dot)net>
To: Trevor Talbot <quension(at)gmail(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>, Dave Page <dpage(at)postgresql(dot)org>
Subject: Re: 8.2.3: Server crashes on Windows using Eclipse/Junit
Date: 2007-11-12 13:07:26
Message-ID: 20071112130726.GJ10213@svr2.hagander.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

On Mon, Nov 12, 2007 at 04:00:04AM -0800, Trevor Talbot wrote:
> On 11/12/07, Magnus Hagander <magnus(at)hagander(dot)net> wrote:
> > On Sat, Nov 10, 2007 at 03:17:13PM -0800, Trevor Talbot wrote:
>
> > > As for desktop heap, only 65KB of the service heap was allocated, or
> > > about 80 bytes per connection. No danger of hitting limits in the
> > > kernel memory pools either.
> >
> > As Dave said, it could be that the server version uses a lot less heap per
> > process, which would be another good reason to use server rather than XP to
> > run postgresql. But might there also be other differences, such as some
> > third party (or non-core microsoft) product installed?
>
> The XP SP2 machine I tried 8.2.5 on was chewing up about 3.1KB per
> process, and it's not running anything invasive (AV or otherwise).

Then I think we can claim that Server is just better than Workstation in
this regard. Maybe we should put that in the FAQ?

> I've been trying to find out exactly what's in the desktop heap, but I
> haven't had much luck so far. Apparently Microsoft changed the
> implementation after Win2000, and didn't bother teaching the public
> debugging tools about it. The details just don't seem to exist
> anymore :(

Yeah, there are very little docs at all about the desktop heap AFAICT.

//Magnus

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message John DeSoi 2007-11-12 13:15:53 Re: Verison 8.3 PL/pgSQL debugger Question
Previous Message Lars Haugseth 2007-11-12 13:03:58 Re: Duplicating a table row while honouring key constraints

Browse pgsql-hackers by date

  From Date Subject
Next Message Simon Riggs 2007-11-12 13:08:10 Re: [hibernate-team] PostgreSQLDialect
Previous Message Richard Huxton 2007-11-12 12:45:24 Re: Clarification reqeusted for "select * from a huge table"