| 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: | Whole Thread | Raw Message | 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 |