Re: Default shared memory SGML mention
От | Bruce Momjian |
---|---|
Тема | Re: Default shared memory SGML mention |
Дата | |
Msg-id | 200105082111.f48LB5E03982@candle.pha.pa.us обсуждение исходный текст |
Ответ на | Re: Default shared memory SGML mention (Tom Lane <tgl@sss.pgh.pa.us>) |
Список | pgsql-docs |
> Bruce Momjian <pgman@candle.pha.pa.us> writes: > > Yes, but shared memory limits are based on buffers, not connections, > > right? The per-connection overhead is pretty small, no? > > I gave you my experimentally-derived formula already: > > 250Kb + 8350 * B + 14580 * N > > I don't see how you can consider the N term negligible. OK, patch applied. -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania 19026 Index: doc/src/sgml/runtime.sgml =================================================================== RCS file: /home/projects/pgsql/cvsroot/pgsql/doc/src/sgml/runtime.sgml,v retrieving revision 1.64 diff -c -r1.64 runtime.sgml *** doc/src/sgml/runtime.sgml 2001/05/07 15:55:27 1.64 --- doc/src/sgml/runtime.sgml 2001/05/08 21:09:21 *************** *** 1481,1487 **** <row> <entry><varname>SHMMAX</></> <entry>Maximum size of shared memory segment (bytes)</> ! <entry>250 kB + 8192 * buffers or infinity</entry> </row> <row> --- 1481,1487 ---- <row> <entry><varname>SHMMAX</></> <entry>Maximum size of shared memory segment (bytes)</> ! <entry>250 kB + 8.2kB * buffers + 14.2kB * max_connections or infinity</entry> </row> <row>
В списке pgsql-docs по дате отправления: