Re: [HACKERS] Open 6.5 items

Поиск
Список
Период
Сортировка
От Vadim Mikheev
Тема Re: [HACKERS] Open 6.5 items
Дата
Msg-id 37534572.8E77A45E@krs.ru
обсуждение исходный текст
Ответ на Re: [HACKERS] Open 6.5 items  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: [HACKERS] Open 6.5 items  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
Tom Lane wrote:
> 
> Tatsuo Ishii <t-ishii@sra.co.jp> writes:
> > I have just done cvs update and saw your changes. I tried the same
> > testing as I did before (64 conccurrent connections, and each
> > connection excutes 100 transactions), but it failed again.
> >
> > (1) without -B 1024, it failed: out of free buffers: time to abort!
> 
> Right now, the postmaster will let you set any combination of -B and -N
> you please.  But it seems obvious that there is some minimum number of
> buffers per backend below which things aren't going to work very well.
> I wonder whether the postmaster startup code ought to enforce a minimum
> ratio, say -B at least twice -N ?  I have no idea what an appropriate               ^^^^^^^^^^^^^^
It's enough for select from single table using index, so it's
probably good ratio.

> limit would be, however.  Vadim, do you have any thoughts?

Vadim


В списке pgsql-hackers по дате отправления:

Предыдущее
От: The Hermit Hacker
Дата:
Сообщение: Re: [HACKERS] IRC meeting
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: [HACKERS] History of PostgreSQL