Search Postgresql Archives

Re: SHMMAX and shared_bufffers

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Scott Marlowe escribió:
> On Tue, Nov 11, 2008 at 10:58 AM, Sam Mason <sam@xxxxxxxxxxxxx> wrote:

> > what is this "extra slop" needed for?

> free space map and temp buffers.  Not sure what else.

Lock space, pg_clog, pg_subtrans and pg_multixact buffers, FSM, and some
other things.  External modules can request additional shared memory
too.  We're not very strict about the accounting.

(temp buffers do not use shared memory -- what would be the point?)

> Note that there could always be some other application using some
> small amount of shared memory.  use ipcs to see it.  Run it as root to
> see other user's / process's shared mem usage.

shmmax is per-process.  It's shmall that's system-wide, but that's
measured in pages and is rarely a problem.

-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.

-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux