Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id C2F9B9FB1EA for ; Tue, 24 Oct 2006 01:49:23 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 53617-08 for ; Tue, 24 Oct 2006 01:49:03 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from bay0-omc1-s19.bay0.hotmail.com (bay0-omc1-s19.bay0.hotmail.com [65.54.246.91]) by postgresql.org (Postfix) with ESMTP id BF8459FA26D for ; Tue, 24 Oct 2006 01:49:02 -0300 (ADT) Received: from hotmail.com ([64.4.38.27]) by bay0-omc1-s19.bay0.hotmail.com with Microsoft SMTPSVC(6.0.3790.1830); Mon, 23 Oct 2006 21:49:02 -0700 Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC; Mon, 23 Oct 2006 21:49:01 -0700 Message-ID: Received: from 64.4.38.200 by by116fd.bay116.hotmail.msn.com with HTTP; Tue, 24 Oct 2006 04:48:56 GMT X-Originating-IP: [66.92.150.53] X-Originating-Email: [bitsandbytes88@hotmail.com] X-Sender: bitsandbytes88@hotmail.com From: "Mr. Dan" To: pgsql-admin@postgresql.org Subject: could not fork new process for connection: Cannot allocate memory Date: Tue, 24 Oct 2006 00:48:56 -0400 Mime-Version: 1.0 Content-Type: text/plain; format=flowed X-OriginalArrivalTime: 24 Oct 2006 04:49:01.0302 (UTC) FILETIME=[B967F160:01C6F727] X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=2.458 tagged_above=0 required=5 tests=AWL, MSGID_FROM_MTA_HEADER, SPF_HELO_SOFTFAIL, SPF_SOFTFAIL X-Spam-Level: ** X-Archive-Number: 200610/147 X-Sequence-Number: 23450 Hi, We are running v814 with 8 GB of RAM and 3.5 GB allocated to shared memory. It's never been a problem for us before. We ran into a situation yesterday where we received the message above. At that time our total available memory took a dive to 4GB and cached memory stayed around 4 GB. Soon after that some process ended and everything returned to normal. It alsted around 10 minutes. Too bad I didn't see the query or process at the time it was running. ~DjK _________________________________________________________________ Try the next generation of search with Windows Live Search today! http://imagine-windowslive.com/minisites/searchlaunch/?locale=en-us&source=hmtagline