Re: [HACKERS] file descriptors leak?

> 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