Skip site navigation (1) Skip section navigation (2)

Re: memory allocation ; postgresql-8.0

From: Scott Marlowe <smarlowe(at)g2switchworks(dot)com>
To: "Kavan, Dan (IMS)" <KavanD(at)imsweb(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: memory allocation ; postgresql-8.0
Date: 2005-05-12 19:07:21
Message-ID: 1115924841.22291.5.camel@state.g2switchworks.com (view raw or flat)
Thread:
Lists: pgsql-admin
On Thu, 2005-05-12 at 12:46, Kavan, Dan (IMS) wrote:
> Do psql calls/procedures access resources reserved from the
> kernel.shmmax?

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
memory.

> 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 LaneDate: 2005-05-12 19:11:36
Subject: Re: Query Plan - Index Scan & Seq Scan
Previous:From: PrasanthDate: 2005-05-12 18:49:01
Subject: Re: Query Plan - Index Scan & Seq Scan

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group