Re: Errors: Too many open files

From: "Steve Wolfe" <steve(at)iboats(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Re: Errors: Too many open files
Date: 2001-12-07 18:57:49
Message-ID: 000d01c17f51$13f6bb60$50824e40@iboats.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> > > echo "8192" > /proc/sys/fs/file-max
> > > (did not seem to make a difference)

You'll probably want to do something like this:

echo '16384' > /proc/sys/fs/file-max
echo '65536' > /proc/sys/fs/inode-max

The documentation in the kernel sources mentions that inode-max should
be something like two or three times the file-max. Also, depending on
your local configuration, you may need to use ulimit to raise the file
limits for that individual user.

It's so much easier than years ago, when you had to recompile the kernel
to raise those limits. ; )

steve

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Holger Krug 2001-12-07 19:06:11 Re: Using Cursor in PostgreSQL 7.2
Previous Message Holger Krug 2001-12-07 18:55:38 Re: Where is PL/Python?