Number of open files

From: "Mark Alliban" <MarkA(at)idnltd(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Number of open files
Date: 2001-02-01 13:31:41
Message-ID: 95bofm$sop$1@news.tht.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

I am having problems with the number of open files on Redhat 6.1. The value
of /proc/sys/fs/file-max is 4096 (the default), but this value is reached
with about 50 ODBC connections. Increasing the file-max value would only
temporarily improve matters because on the long-term I expect to have 500+
active connections. How comes there are so many open files per connection?
Is there any way to decrease the number of open files, so that I don't have
to increase file-max to immense proportions?

Thanks,
Mark.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Raymond Chui 2001-02-01 13:56:44 Re: Unrecognized language plpgsql when CREATE FUNCTION?!
Previous Message Gianfranco Masia - Eprom s.r.l. 2001-02-01 12:44:35 how retrive user IP address