From: | Ruben Rubio <ruben(at)rentalia(dot)com> |
---|---|
To: | pgsql-performance(at)postgresql(dot)org |
Subject: | shared_buffer optimization |
Date: | 2006-08-08 10:40:00 |
Message-ID: | 44D86A00.90106@rentalia.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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-----
From | Date | Subject | |
---|---|---|---|
Next Message | Stephen Frost | 2006-08-08 12:05:29 | Re: Hardware upgraded but performance still ain't good enough |
Previous Message | kumarselvan | 2006-08-08 08:42:02 | BUG #2567: High IOWAIT |