On Mon, Nov 12, 2007 at 04:00:04AM -0800, Trevor Talbot wrote: > On 11/12/07, Magnus Hagander <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match