Re: Troubles with performances

From: Lamar Owen <lamar(dot)owen(at)wgcr(dot)org>
To: Warren Vanichuk <pyber(at)street-light(dot)com>
Cc: "Mikheev, Vadim" <vmikheev(at)SECTORBASE(dot)COM>, pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Troubles with performances
Date: 2001-01-18 21:06:15
Message-ID: 3A675AC7.4D166BB9@wgcr.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Warren Vanichuk wrote:
> IpcMemoryCreate: shmget failed (Invalid argument) key=5432001, size=143193088, permission=600

> -o -F -B 2048 -N 512 -S 4096

Ok, you have 2048 8K buffers, and up to 512 backends. If you're trying
to set SortSize to 4096, you need quotes around it and a -o, AFAIK, asx
the -S postmaster option sets silent mode.

Further along,

According to the shmget man page:

The followings are limits on shared memory segment
resources affecting a shmget call:

SHMALL System wide maximum of shared memory pages:
policy dependent.

SHMMAX Maximum size in bytes for a shared memory seg­
ment: implementation dependent (currently 4M).

SHMMIN Minimum size in bytes for a shared memory seg­
ment: implementation dependent (currently 1
byte, though PAGE_SIZE is the effective minimum
size).

SHMMNI System wide maximum number of shared memory
segments: implementation dependent (currently
4096).

The implementation has no specific limits for the per pro­
cess maximum number of shared memory segments (SHMSEG).

And from the linux kernel source, includes/asm-i386/shmparam.h:
/*
* Keep _SHM_ID_BITS as low as possible since SHMMNI depends on it and
* there is a static array of size SHMMNI.
*/
#define _SHM_ID_BITS 9
#define SHM_ID_MASK ((1<<_SHM_ID_BITS)-1)

#define SHM_IDX_SHIFT (_SHM_ID_BITS)
#define _SHM_IDX_BITS 15
#define SHM_IDX_MASK ((1<<_SHM_IDX_BITS)-1)

/*
* _SHM_ID_BITS + _SHM_IDX_BITS must be <= 24 on the i386 and
* SHMMAX <= (PAGE_SIZE << _SHM_IDX_BITS).
*/

#define SHMMAX 0x2000000 /* max shared seg size (bytes)
*/
/* Try not to change the default shipped SHMMAX - people rely on it */

-------

Hmmmm....

Looks pretty difficult to change.
--
Lamar Owen
WGCR Internet Radio
1 Peter 4:11

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Oliver Elphick 2001-01-18 21:09:22 Re: Problem with starting my db with Postmaster
Previous Message Lamar Owen 2001-01-18 20:25:44 Re: Re: MS Access data to PostgrSQL data