On Thu, 2005-05-12 at 12:46, Kavan, Dan (IMS) wrote:
> Do psql calls/procedures access resources reserved from the
Only in the sense that it can execute a query, which in the backend
could therefore use shared memory. psql, itself, doesn't use shared
> How about the tar or copy sysadmin commands? I would guess they don't
> use kernel.shmmax resources.
Correct. Actually, very few types of programs use shared memory.
> Finally, work memory alos does not access
> resources reserved from kernel.shmmax, correct?
Correct. The only parts of postgresql.conf that affect shared memory
usage are max connections, shared buffers, and the fsm.
In response to
pgsql-admin by date
|Next:||From: Tom Lane||Date: 2005-05-12 19:11:36|
|Subject: Re: Query Plan - Index Scan & Seq Scan |
|Previous:||From: Prasanth||Date: 2005-05-12 18:49:01|
|Subject: Re: Query Plan - Index Scan & Seq Scan|