Re: [GENERAL] leaking FD's ?

> > Hi
> >
> > I am running a process that does a fair number of selects and updates but
> > nothing too complex.
> >
> > I have the postmaster starting like such:
> >
> > /usr/bin/postmaster -o "-F -S 10240" -d 1 -N 128 -B 256 -D/var/lib/pgsql/data -o -F > /tmp/postmasterout 2> /tmp/postmastererr
> >
> > Now, looking at that, I have 256 shared memory segments, and as such,
> > I would expect the number of file descriptors used by my backends to
> > be fairly similar.
>
> Each backend keeps up to 64(?) file descriptors open, expecting it may
> need to access those files in the future, so it uses it as a cache.

Thats fine, except for, as I stated, I was up to 480 at time of writing. As
time progressed, the number of FDs open maxed out at 1022, which considering
I have a max of 1024 per process seems to say to me that it was leaking.
Especially as it became increasingly slower as it went after hitting 1022
which to me indicates that, as you say, it held fd's open for caching, but
when it reached its fd limit and still leaked, it had less and less free fds
to play with.

Sound like a leak to anyone?

~Michael