file descriptors

From: "David Parker" <dparker(at)tazznetworks(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: file descriptors
Date: 2005-02-11 22:56:48
Message-ID: 07FDEE0ED7455A48AC42AC2070EDFF7C48BC9D@corpsrv2.tazznetworks.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

We have started getting the error

FATAL: terminating connection due to administrator command

in some of our processes. Searching in the archives, I gather that this
is caused by a SIGTERM, and might be coming from a ulimit problem.

We are running Solaris 9/Intel, and the ulimit for nofiles for the
database owner process is 256. I suspect this needs to be set to
"unlimited", which I don't think should cause a problem on Solaris (?).

Is there any rule of thumb for determining how many file descriptors a
given postmaster would use, e.g., a way to find out how many data files
exist on the server, and/or an estimate for how many of them would have
to be open at any given time? Do ALL of the data files get kept open, or
do they get opened and closed?

Thanks.

- DAP
------------------------------------------------------------------------
----------
David Parker Tazz Networks (401) 709-5130


Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2005-02-11 23:09:14 Re: databases/p5-postgresql-plperl links to wrong libperl.so
Previous Message Tom Lane 2005-02-11 22:40:56 Re: Hello...