From: Tom Lane <tgl@sss.pgh.pa.us>
To: Command Prompt, Inc. <pgsql-general@commandprompt.com>
Cc: Steve Lane <slane@fmpro.com>
Cc: jlx@commandprompt.com
Cc: pgsql-general@postgresql.org
Subject: Re: MacOS X Shared Buffers (SHMMAX)?
Date: Wed, 22 May 2002 13:20:32 -0400
Message-ID: <11281.1022088032@sss.pgh.pa.us> (raw)
In-Reply-To: <Pine.LNX.4.30.0205220939590.14696-100000@commandprompt.com>
References: <Pine.LNX.4.30.0205220939590.14696-100000@commandprompt.com>
"Command Prompt, Inc." <pgsql-general@commandprompt.com> 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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: tgl@sss.pgh.pa.us, pgsql-general@commandprompt.com, slane@fmpro.com, jlx@commandprompt.com, pgsql-general@postgresql.org
Subject: Re: MacOS X Shared Buffers (SHMMAX)?
In-Reply-To: <11281.1022088032@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox