Serge Sozonoff wrote:
>
> Since then I have been observeing /proc/sys/fs/file-nr and I noticed that the
> system has already spiked to 8192 open files. I have also seen it sitting
> steady at 7356 open files.
> d
> I was interested to know if this is "normal" behavior for Postgres, using
> "lsof" I noticed
> that most of the open files belonged to postmaster and most of them were
> not sockets.
Your numbers do not surprise me at all. Backend pgsql servers live
for the lifetime of the client connection, and they open a similarly
large number of files on my system. I throttle them by throttling the
life of the apache children who are generally the only clients.
Cheers,
Ed Loehr