Linux / PostgreSQL question - Mailing list pgsql-hackers

From Mitch Vincent
Subject Linux / PostgreSQL question
Date
Msg-id 00ce01c01dbd$d57912c0$0200000a@doot
Whole thread Raw
Responses Re: Linux / PostgreSQL question
List pgsql-hackers
I was just doing some huge operations with PostgreSQL and it all crashed out
with a "too many files open" message plastered all over the place..

Now in /proc/sys/fs/file-max there is only 4096, that limit could have
easily been reached. Does changing the value in the file effectively change
the limit system-wide? I changed it and rebooted but it was set right back
to 4096.. I've been out of the Linux loop for a long time (FreeBSD junkie
now) so I don't know how to set that up to permanently change the limit.

Marc: You use Linux, don't you? Have you ever run into this?

Any help is very appreciated, thanks!

-Mitch




pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Indexing of LIKE queries is broken in current sources
Next
From: teg@redhat.com (Trond Eivind Glomsrød)
Date:
Subject: Re: Linux / PostgreSQL question