Re: [ADMIN] shared_buffers and shmmax
| От | Tom Lane |
|---|---|
| Тема | Re: [ADMIN] shared_buffers and shmmax |
| Дата | |
| Msg-id | 17528.1229470697@sss.pgh.pa.us обсуждение |
| Ответ на | Re: [ADMIN] shared_buffers and shmmax (Bruce Momjian <bruce@momjian.us>) |
| Ответы |
Re: [ADMIN] shared_buffers and shmmax
|
| Список | pgsql-docs |
Bruce Momjian <bruce@momjian.us> writes:
> OK, updated patch. I added item descriptions and removed Alvaro's
> paragraph; I worked with Alvaro on this patch.
This still seems pretty misleading, as for example
> <tbody>
> <row>
> <entry><xref linkend="guc-max-connections"></>
> ! <entry>1800 + 270 * <xref
> ! linkend="guc-max-locks-per-transaction"> bytes per connection</entry>
> </row>
sounds like it might mean bytes per *active* connection, when of course
the correct way to figure it is by multiplying by max_connections.
If you're going to give a formula, why not just give a formula, eg
(1800 + 270 * max_locks_per_transaction) * (max_connections + autovacuum_max_workers)
regards, tom lane
В списке pgsql-docs по дате отправления: