From: | Tom <tom(at)sdf(dot)com> |
---|---|
To: | Oleg Bartunov <oleg(at)sai(dot)msu(dot)su> |
Cc: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: [HACKERS] number of opened files ? |
Date: | 1998-08-04 04:03:11 |
Message-ID: | Pine.BSF.3.95q.980803205919.28908B-100000@misery.sdf.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On Mon, 3 Aug 1998, Oleg Bartunov wrote:
> 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 ?
Postgres will keep a some files open.
> This is amazing. Do postgres really needs to keep so much open files ?
443 is not that many.
> I use apache+mod_perl and Apache::DBI for authent./authorization
> and it's not difficult to reach file table limit when running
Huh? Most systems have a file table limit of several thousand. I think
you need to check it into this. I have a max of 2088 descriptors on most
systems here, and I double that if necessary.
> 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(at)sai(dot)msu(dot)su, http://www.sai.msu.su/~megera/
> phone: +007(095)939-16-83, +007(095)939-23-83
Tom
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 1998-08-04 04:40:40 | Re: [HACKERS] indexes and floats |
Previous Message | Tom Lane | 1998-08-04 03:50:47 | Re: [HACKERS] indexes and floats |