Re: Re: Too many open files (was Re: spinlock problems reported earlier)

Поиск
Список
Период
Сортировка
От The Hermit Hacker
Тема Re: Re: Too many open files (was Re: spinlock problems reported earlier)
Дата
Msg-id Pine.BSF.4.21.0008281615240.564-100000@thelab.hub.org
обсуждение исходный текст
Ответ на Re: Re: Too many open files (was Re: spinlock problems reported earlier)  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Alfred Perlstein
Дата:
Сообщение: INHERITS doesn't offer enough functionality
Следующее
От: Hannu Krosing
Дата:
Сообщение: Re: SQL COPY syntax extension (was: Performance on inserts)