Re: Re: Too many open files (was Re: spinlock problems reported earlier) - Mailing list pgsql-hackers

From The Hermit Hacker
Subject Re: Re: Too many open files (was Re: spinlock problems reported earlier)
Date
Msg-id Pine.BSF.4.21.0008281615240.564-100000@thelab.hub.org
Whole thread Raw
In response to Re: Re: Too many open files (was Re: spinlock problems reported earlier)  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
On Mon, 28 Aug 2000, Tom Lane wrote:

> The only straightforward implementation is to take the parameter,
> divide by MaxBackends, and allow each backend to have no more than
> that many files open.  Any sort of dynamic allocation would require
> inter-backend communication, which is probably more trouble than it's
> worth to avoid a few kernel calls.

agreed, just wanted to make sure ... sound great to me ...

> > (note. I'm running with 192 backends right now,
> > and have actually pushed it to run 188 simultaneously *grin*) ...
> 
> Lessee, 8192 FDs / 192 backends = 42 per backend.  No wonder you were
> running out.

*grin*  I up'd it to 32k ... so far its max'd out at around 7175used ...




pgsql-hackers by date:

Previous
From: Alfred Perlstein
Date:
Subject: INHERITS doesn't offer enough functionality
Next
From: Hannu Krosing
Date:
Subject: Re: SQL COPY syntax extension (was: Performance on inserts)