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