> On Tue, 2 Nov 1999, Tom Lane wrote:
>
> > Date: Tue, 02 Nov 1999 10:18:15 -0500
> > From: Tom Lane <tgl@sss.pgh.pa.us>
> > To: Gene Sokolov <hook@aktrad.ru>
> > Cc: pgsql-hackers@postgreSQL.org
> > Subject: Re: [HACKERS] file descriptors leak?
> >
> > "Gene Sokolov" <hook@aktrad.ru> writes:
> > > We disconnected all clients and the number of descriptors dropped from 800
> > > to about 200, which is reasonable. We currently have 3 connections and ~300
> > > used descriptors. The "lsof -u postgres" is attached.
> >
> > Hmm, I see a postmaster with 8 open files and one backend with 34.
> > Doesn't look out of the ordinary to me.
>
> I see 617 open files (using lsof| grep post | wc).
> This is a Linux 2.0.37, postgres 6.5.3, 1 postamster and
> 10 backends. I already complained about this and would glad
> to understand now is it ok or postgres just wast fd ?
PostgreSQL caches up to 64 file descriptors per backend, meaning it keep
them open in case it needs them later. The 617 number for 10 backend
sounds just about right.
-- Bruce Momjian | http://www.op.net/~candle maillist@candle.pha.pa.us | (610)
853-3000+ If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill,
Pennsylvania19026