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
|
Список | 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 по дате отправления: