Re: Win32 max connections bug (causing crashes)

From: "Magnus Hagander" <mha(at)sollentuna(dot)net>
To: "Merlin Moncure" <mmoncure(at)gmail(dot)com>, "William ZHANG" <uniware(at)zedware(dot)org>, "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
Cc: <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Win32 max connections bug (causing crashes)
Date: 2006-08-18 10:46:27
Message-ID: 6BCB9D8A16AC4241919521715F4D8BCEA35536@algol.sollentuna.se
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

> > Maybe this article can help:
> >
> > Windows and the ClearCase process limit: Understanding the
> desktop
> > heap
> > http://www-
> 128.ibm.com/developerworks/rational/library/05/1220_marecha
> > l/
> >
>
> i doubled all my heap settings and was able to roughly double the -
> c
> on pgbench from ~158 (stock) to ~330 (modified). so this is
> definately the problem.

If you try decreasing max_files_per_process to a significantly lower
value (say, try 100 instead of 1000), does the number of processes you
can run change noticeably?

(I don't have a box around ATM that I can try to reproduce on. Will try
to set up a VM for it soon.)

//Magnus

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message ITAGAKI Takahiro 2006-08-18 10:50:12 Re: Removing the performance gap caused by CHECKPOINT
Previous Message Christopher Kings-Lynne 2006-08-18 08:50:30 Sorry about the GIN docs :(