number of opened files ?
Oleg Bartunov <oleg@sai.msu.su>
From: Oleg Bartunov <oleg@sai.msu.su>
To: pgsql-hackers@postgreSQL.org
Date: 1998-08-03T12:44:31Z
Lists: pgsql-hackers
Hi, How many files really needed for postgres ? On my Linux box I checked this by lsof and found 443 open files (and sockets) by 7 backends + 1 postmaster ? This is amazing. Do postgres really needs to keep so much open files ? I use apache+mod_perl and Apache::DBI for authent./authorization and it's not difficult to reach file table limit when running 15 httpd daemons + 15 backends. I use persistent connections, so backends will stay alive. A number of backends could grow if I use different connection string (I try to avoid this). This is my development computers and there are another bunch of processes (X, window manager etc). Regards, Oleg _____________________________________________________________ Oleg Bartunov, sci.researcher, hostmaster of AstroNet, Sternberg Astronomical Institute, Moscow University (Russia) Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/ phone: +007(095)939-16-83, +007(095)939-23-83