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(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026