Re: Too Many Open Files... NetBSD - Mailing list pgsql-general

From Bruce Momjian
Subject Re: Too Many Open Files... NetBSD
Date
Msg-id 200112182220.fBIMK4514027@candle.pha.pa.us
Whole thread Raw
In response to Too Many Open Files... NetBSD  ("Ian Harding" <ianh@tpchd.org>)
List pgsql-general
> Argh.  I have finally come to the point where i have to pay
> attention to this nuts and bolts stuff.
>
> I get:  ERROR:  pltcl: couldn't create pipe: too many open files
>
> Is this the issue that requires setting options and recompiling
> my kernel like :
>
> <Bruce's article>
>
> FreeBSD NetBSD OpenBSD The options SYSVSHM and SYSVSEM need to
> be enabled when the kernel is compiled. (They are by default.)
> The maximum size of shared memory is determined by the option
> SHMMAXPGS (in pages). The following shows an example of how to
> set the various parameters:

Did I write this?  I think this is from the official documentation,
though I do link to it from my hardware performance tuning article.

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

pgsql-general by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: More on Too Many Open Files... NetBSD
Next
From: Joe Koenig
Date:
Subject: Re: Way to use count() and LIMIT?