Re: open pgsql files (was Re: [GENERAL] Mime-Version: 1.0)

> > If I have 40 tables and each table is made up of 6-7 files including
> > index's etc then that
> > means that per process I could be opening up to 200-240 !!
> >
> > This means that with 64 db connections I could be hitting  12800-15360 open
> > files
> > on my system!!! What is the current Linux limit without kernel re-compile?
> > What is the Linux
> > limit with kernel re-compile?
> >
> > Why can't I just tell postgres to close thos files say 2 minutes after he
> > is done with them
> > and they have been idle?
>
> Take a look at /pg/backend/storage/file/fd.c::pg_nofile().  If you
> change the line:

This actually brings up a good point.  We currently cache all
descriptors up to the limit the OS will allow for a process.

Is this too aggressive?  Should we limit it to 50% of the maximum?


--
  Bruce Momjian                        |  http://www.op.net/~candle
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026