shared_buffer optimization - Mailing list pgsql-performance

From Ruben Rubio
Subject shared_buffer optimization
Date
Msg-id 44D86A00.90106@rentalia.com
Whole thread Raw
List pgsql-performance
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hi, I have a question with shared_buffer.

Ok, I have a server with 4GB of RAM
- -----
# cat /proc/meminfo
MemTotal:      4086484 kB
[...]
- -----

So, if I want to, for example, shared_buffer to take 3 GB of RAM then
shared_buffer would be 393216 (3 * 1024 * 1024 / 8)

Postmaster dont start.
Error: FATAL:  shmat(id=360448) failed: Invalid argument


I can set a less value, but not higher than 3 GB.

Am I doing something wrong?
Any idea?
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.2.2 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFE2GoAIo1XmbAXRboRAtPgAJ9HN7aL0lyFtyTZnOoIAJXmGNsomgCeI1ex
II1MclZaaIjg/ryH08wCuAY=
=cgwJ
-----END PGP SIGNATURE-----

pgsql-performance by date:

Previous
From: Eugeny N Dzhurinsky
Date:
Subject: vacuuming
Next
From: Stephen Frost
Date:
Subject: Re: Hardware upgraded but performance still ain't good enough