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

From Doug McNaught
Subject Re: More on Too Many Open Files... NetBSD
Date
Msg-id m33d2817pt.fsf@varsoon.denali.to
Whole thread Raw
In response to More on Too Many Open Files... NetBSD  ("Ian Harding" <ianh@tpchd.org>)
List pgsql-general
"Ian Harding" <ianh@tpchd.org> writes:

> Having no idea what i am looking for, I find...
>
> bash-2.05$ ulimit -a
[...]
> open files                  64

This is pretty low.  Each PG backend can open a lot of files with a
large database.  I'd try cranking it up in the script that starts PG.

> bash-2.05$ sysctl kern.maxfiles
> kern.maxfiles = 1772

If this is the systemwide limit it also might be a bit low.  It's more
likely to be the ulimit that's biting you though.

-Doug
--
Let us cross over the river, and rest under the shade of the trees.
   --T. J. Jackson, 1863

pgsql-general by date:

Previous
From: "Andrew G. Hammond"
Date:
Subject: Re: Is there a PostgresQL equivalent to the DESCRIBE
Next
From: "Adam Fisher"
Date:
Subject: another foreign key question