Re: Linux / PostgreSQL question - Mailing list pgsql-hackers

From teg@redhat.com (Trond Eivind Glomsrød)
Subject Re: Linux / PostgreSQL question
Date
Msg-id xuylmww2goq.fsf@hoser.devel.redhat.com
Whole thread Raw
In response to Linux / PostgreSQL question  ("Mitch Vincent" <mitch@venux.net>)
List pgsql-hackers
"Mitch Vincent" <mitch@venux.net> writes:

> 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.. 

A reboot would reset values in proc...

For Red Hat Linux 6.2 and up, you would add a line to
/etc/sysctl.conf:

# Max open files:
fs.file-max = 8192

-- 
Trond Eivind Glomsrød
Red Hat, Inc.


pgsql-hackers by date:

Previous
From: "Mitch Vincent"
Date:
Subject: Linux / PostgreSQL question
Next
From: "Ross J. Reedstrom"
Date:
Subject: Re: Linux / PostgreSQL question