Received: from localhost.localdomain (postgresql.org [64.49.215.8]) by localhost (Postfix) with ESMTP id 4CC7747631C for ; Wed, 22 May 2002 13:24:20 -0400 (EDT) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by postgresql.org (Postfix) with ESMTP id 5994D476556 for ; Wed, 22 May 2002 13:21:20 -0400 (EDT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.11.4/8.11.4) with ESMTP id g4MHKWW11284; Wed, 22 May 2002 13:20:32 -0400 (EDT) To: "Command Prompt, Inc." Cc: Steve Lane , jlx@commandprompt.com, pgsql-general@postgresql.org Subject: Re: MacOS X Shared Buffers (SHMMAX)? In-reply-to: References: Comments: In-reply-to "Command Prompt, Inc." message dated "Wed, 22 May 2002 10:30:00 -0700" Date: Wed, 22 May 2002 13:20:32 -0400 Message-ID: <11281.1022088032@sss.pgh.pa.us> From: Tom Lane X-Archive-Number: 200205/775 X-Sequence-Number: 24755 "Command Prompt, Inc." writes: > I was able to pull down the source for the Kernel, and increased the > SHMMAX by a factor of 16. Upgraded to the new Kernel and I am now able to > get safely 512 connections, even up around 900, but bumping it up to 1024, > I run into the following error: > PGSTATBUFF: recvfrom(2): Resource temporarily unavailable > DEBUG: statistics collector process (pid 1988) exited with exit code 1 > ...which then repeats itself infinitely until the calling process is > stopped. ;) [ scratches head... ] "Resource temporarily unavailable" is EAGAIN according to /usr/include/sys/errno.h on my OSX machine. But the man page for recvfrom doesn't mention any plausible reasons for EAGAIN to be signaled. select() just told us there was data available on the socket, so WTF? Could this be a kernel bug? You could try modifying pgstat.c to continue its loop rather than exiting after it gets a recvfrom error. But if the error condition recurs that'll just put pgstat.c into an infinite loop, so I'm not sure this is any solution --- just a way of gathering more data. regards, tom lane