From: Jessica Richard <rjessil@yahoo.com>
To: pgsql-performance@postgresql.org
Subject: best starting point...
Date: Sat, 12 Jul 2008 05:03:13 -0700 (PDT)
Message-ID: <634968.89924.qm@web56402.mail.re3.yahoo.com> (raw)
On a new system with 64G memory, what is the best starting points for shmmax on OS and shared_buffers for Postgres. All databases combined are about 50G.
I want to evaluate this with the two following scenarios:
1. this machine is running only Postgres, no other applications
2. this machine has postgres plus some other things (such as web server, etc).
What are the dangers for shmmax and shared_buffers to be confiugred very big for each of the two scenarios?
In case #1, if shmmax = 63G and shared_buffers = 50G, can it speed up Postgres (loading almost all dbs into memeory)?
Thanks,
Jessica
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: rjessil@yahoo.com
Subject: Re: best starting point...
In-Reply-To: <634968.89924.qm@web56402.mail.re3.yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox