From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
---|---|
To: | Ian Harding <ianh(at)tpchd(dot)org> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Too Many Open Files... NetBSD |
Date: | 2001-12-18 22:20:04 |
Message-ID: | 200112182220.fBIMK4514027@candle.pha.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
From | Date | Subject | |
---|---|---|---|
Next Message | Darren Ferguson | 2001-12-18 22:22:22 | Re: Way to use count() and LIMIT? |
Previous Message | SHELTON,MICHAEL (Non-HP-Boise,ex1) | 2001-12-18 22:01:13 | Re: Way to use count() and LIMIT? |